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
|