Link to home
Create AccountLog in
Avatar of joeserrone
joeserrone

asked on

Avoid #N/A in Match Excel Formula

I have the following formula:
=INDEX('Project Lookup'!A:A,MATCH(A1,'Project Lookup'!B:B,0))

How can I avoid seeing #N/A and simply substitute it with nothing "" when nothing is present in A1 ?
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
for 2003 try

=if(isna(MATCH(A1,'Project Lookup'!B:B,0)),"",INDEX('Project Lookup'!A:A,MATCH(A1,'Project Lookup'!B:B,0)))
If you say you want a blank if nothing is in A1, which is your lookup value in the MATCH function...

=IF(A1="","",INDEX('Project Lookup'!A:A,MATCH(A1,'Project Lookup'!B:B,0)))
Avatar of joeserrone
joeserrone

ASKER

Thank you!