SOMEONE CAN HELP ?

[Guest]

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(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

 

[ward376]

try -

=IF(ISERROR(VLOOKUP(B1,IF(C1>0,Exp2,Exp),2,)),"
",(VLOOKUP(B1,IF(C1>0,Exp2,Exp),2,)))

 

[Guest]

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