Multi Vlookup #N/A Error !
 

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

Multi Vlookup #N/A Error !
 

Try This

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

Mike

"Tufail" wrote:

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

Multi Vlookup #N/A Error !
 

In the help index type in iserr and look at the is functions

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tufail" wrote in message
...
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

Multi Vlookup #N/A Error !
 

perfect, excellent !
thanks


"Mike H" wrote:

Try This

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

Mike

"Tufail" wrote:

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

Multi Vlookup #N/A Error !
 

Glad I could help

"Tufail" wrote:

perfect, excellent !
thanks


"Mike H" wrote:

Try This

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

Mike

"Tufail" wrote:

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