You will need a MATCH within the INDEX part of the formula, like this:

=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,MATCH(A10&"_"&ROW(#R EF!),'[Query for
Analysis Decks.xls]Query_for_Analysis_Decks'!AE:AE,0)))

BUT, you do have #REF in the ROW function, so you will need to correct that
in two places before this will work (presumably you deleted the row that it
referred to).

Hope this helps.

Pete


"Toria" wrote in message
...
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!