View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toria Toria is offline
external usenet poster
 
Posts: 38
Default Need Help with Lookup Formula that Also Puts in Text Where Matchin

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!