MATCH a Web Query

[mpduffey]

I cannot seem to get the Match function to work on a table tha
refreshes from a WebQuery. I have followed the Excel Online webpag
instructions for inputing the offset/match formula to pull a valu
based on a set value in an adjacent column. The formula returns th
correct value if the table is entered manually, but won;t read off o
the Query. Do Excel formulas analyze data from a Query? I am confused
. . Thank yuo for any input

 

[Jonathan Rynd]

I cannot seem to get the Match function to work on a table that
refreshes from a WebQuery. I have followed the Excel Online webpage
instructions for inputing the offset/match formula to pull a value
based on a set value in an adjacent column. The formula returns the
correct value if the table is entered manually, but won;t read off of
the Query. Do Excel formulas analyze data from a Query? I am confused .
. Thank yuo for any input.

You probably have to recalculate the spreadsheet after the query refreshes.