MULTI VLOOKUP error #N/A
 

Hello,
I am using this formula =VLOOKUP(B1,IF(C10,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

MULTI VLOOKUP error #N/A
 

Hi Tufail,

This is how i get round i
=if(iserr(VLOOKUP(B1,IF(C10,Exp2,Exp),2,);"";VLOO KUP(B1,IF(C10,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

"Tufail" wrote:

Hello,
I am using this formula =VLOOKUP(B1,IF(C10,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

MULTI VLOOKUP error #N/A
 

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.

"DDonnachie" wrote:

Hi Tufail,

This is how i get round it
=if(iserr(VLOOKUP(B1,IF(C10,Exp2,Exp),2,);"";VLOO KUP(B1,IF(C10,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

"Tufail" wrote:

Hello,
I am using this formula =VLOOKUP(B1,IF(C10,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

MULTI VLOOKUP error #N/A
 

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

MULTI VLOOKUP error #N/A
 

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