Hi Toria,

Let me know if this works for you.

=IF(ISNA(MATCH(A1,Query_for_Analysis_Decks!AE:AE,0 ))=TRUE,"",INDIRECT("Query_for_Analysis_Decks!G"&M ATCH(A1,Query_for_Analysis_Decks!AE:AE,0)))

Thanks,
Peggy

"Toria" wrote:

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!