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