MULTI VLOOKUP error #N/A

[Guest]

Hello,
I am using this formula =VLOOKUP(B1,IF(C1>0,Exp2,Exp),2,) now problam is
that when cell C1 empty this error is coming out #N/A now plz tell me what
should i do for this error, i means i waon't show this error even C1 is empty.
Thanks/Tufail

 

[Guest]

Hi Tufail,

This is how i get round i
=if(iserr(VLOOKUP(B1,IF(C1>0,Exp2,Exp),2,);"";VLOOKUP(B1,IF(C1>0,Exp2,Exp),2,))

There are probably better solutions but using IF and ISERR was the first I
came across when I was looking.

Hope it helps

 

[Guest]

very sorry to say could you check it again coz it's doesn't work here, i
think some problam in coulm sing --> ;"";VLOOKUP
waiting your prompt action.

 

[DAV135]

You need to replace the ; with whatever delimiter you're using. Most
probably a comma.

 

[DAV135]

You need to replace the ; with whatever you have as your delimiter.
Most probably a comma.