Multi Vlookup #N/A Error !

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
 
M

Mike H

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
 
T

Tufail

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...
 
Top