i still have an error in following formula in -- ;""; place

thanks/tufail

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

try -

=IF(ISERROR(VLOOKUP(B1,IF(C10,Exp2,Exp),2,)),"
",(VLOOKUP(B1,IF(C10,Exp2,Exp),2,)))

it's working very well, thank you very much.
tufail

"ward376" wrote:

try -

=IF(ISERROR(VLOOKUP(B1,IF(C10,Exp2,Exp),2,)),"
",(VLOOKUP(B1,IF(C10,Exp2,Exp),2,)))