I am trying to use an index/match formula to pull data from a Query table in my work book, onto another sheet, based on common stock numbers.
I have tried several things, and none of them seem to be working. First I tried this simple little formula:
=INDEX(QUERY!A:B,MATCH(A2,A:A,0),2)
which produced #N/A, so I tried the following:
=INDEX(QUERY!A:I,MATCH(A2,INDEX(QUERY!A:I,,1),0),MATCH($B$1,INDEX(QUERY!A:I,1,),0))
with the same results.
Is there something special about indexing a query that I am unaware of?
I am attaching an example, but obviously it does not include the query.
Bookmarks