This is a heavily interactive web application, and JavaScript is required. Simple HTML interfaces are possible, but that is not what this is.
Post
Ken Puls, FCPA, MS MVP
excelguru.ca
did:plc:xpiehblln2cworixrwklvoyv
Replicating VLOOKUP’s exact match is REALLY easy in #PowerQuery. But the approximate match is a little harder to do, since you don’t have matching records on each side to merge together. Here's my take on how to do it: https://excelguru.ca/creating-a-vlookup-function-in-power-query/
#Excel #PowerBI #DataAnalysis
2025-01-06T19:04:56.559Z