MATCH a Web Query

  • Thread starter Thread starter mpduffey
  • Start date Start date
M

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
 
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.
Click to expand...

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