Thanks Eric, I tried yours first and it worked perfectly. Thank youTry:
Excel Formula:=IFERROR(VLOOKUP(A418,[EchoHomeNov21.xlsx]Echo!$A:$G,7,FALSE),"-")
Got it working. Thanks for the replyHi
Untested.Excel Formula:=XLOOKUP(A418,[EchoHomeNov21.xlsx]Echo!$A:$A,[EchoHomeNov21.xlsx]Echo!$G:$G,0)