Thread
:
Multi Vlookup #N/A Error !
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett