Multi Vlookup #N/A Error !

  • Thread starter Thread starter Tufail
  • Start date Start date
T

Tufail

hello all,
i am using following multi vlookup formula but when ther isn't any value
then #N/A error is coming out, how can i avoid it ?

=VLOOKUP($A1,IF($B1="Standard Charter Bank USD",ExrSCB,ExrMB),2,)

thanks in advance
 
Try This

=IF(ISNA(VLOOKUP($A1,IF($B1="Standard Charter Bank
USD",ExrSCB,ExrMB),2,)),"",VLOOKUP($A1,IF($B1="Standard Charter Bank
USD",ExrSCB,ExrMB),2,))

Mike
 
perfect, excellent !
thanks


Mike H said:
Try This

=IF(ISNA(VLOOKUP($A1,IF($B1="Standard Charter Bank
USD",ExrSCB,ExrMB),2,)),"",VLOOKUP($A1,IF($B1="Standard Charter Bank
USD",ExrSCB,ExrMB),2,))

Mike
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP returning #N/A result 2
Error message #N/A 3
IF/VLOOKUP with #N/A results 6
#N/A Conditional Formating 2
Remove #N/A Error 3
Vlookup - N/A 4
Vlookup #N/A 5
Vlookup incorrect #n/a error 9

Back
Top