Passing Parameter in Power Query

Hi

In the attached sample, I have power query and I want to pass parameters from Column B and get relevant outpout in Column C. No of rows of data is only example and may increase or decrease

requesting help

It is difficult to see what your "lookup table" looks like without the necessary credentials to access the web data. Assuming I can guess what the web data looks like when it is loaded into PQ, I would guess that a "merge" between the web data and your Excel table should do what you are trying to do. See if this tutorial (which uses two tables in Excel and merges them together) helps with what you are trying to do: https://excelchamps.com/power-query/vlookup/

Change your current query into a function - e.g.

Please Login or Register  to view this content.

and rename it as something like fGetPrice

then load your ticker data into Power Query and add a calculated column using =fGetPrice([Ticker])

See attached. Everything is coming back as 0 but I don't know if that's an authentication error or something else.

I had overlooked that your original query returned a table so you'd need to alter the last line to make it just return the value you want, using:

Please Login or Register  to view this content.

I use the code provided by romperstomper and added a couple of stocks and there are no issues. See the attached.