Hello,

I have two different spreadsheets. I'm trying to write a formula that says
if the ID in A1 of the first spreadsheet matches anywhwere in column AE in
the second spreadsheet, put in the text from column G of the second
spreadsheet. This is what I came up with, but it's not putting in the text
from column G of that particular row where there was a match:

=IF(ISNA(MATCH(A10&"_"&ROW(#REF!),'[Query for Analysis
Decks.xls]Query_for_Analysis_Decks'!AE:AE,0)),"",INDEX('[Query for Analysis
Decks.xls]Query_for_Analysis_Decks'!G:G,0))

Many thanks in advance!