VLOOKUP

[Guest]

I do not want to see FALSE if formula`s result is FALSE, but when I copy my
formulas to another worksheet I see it. How I can get rid of it ? nPlease,
help.
=IF(E11=2;VLOOKUP(C11;Taux;3);IF(E11=3;VLOOKUP(C11;Taux;4)))

 

[Bob Phillips]

=IF(E11=2;IF(ISNA(VLOOKUP(C11;Taux;3));"";VLOOKUP(C11;Taux;3));IF(E11=3;IF(I
SNA(VLOOKUP(C11;Taux;4));"";VLOOKUP(C11;Taux;4))))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

Maybe...

=IF(E11=2;VLOOKUP(C11;Taux;3);IF(E11=3;VLOOKUP(C11;Taux;4);""))

 

[Owen]

This might simplify for you:

if(countif(C11,Taux)=0,"",VLOOKUP(C11;Taux;e11+1))

HTH
Owen

 

[Don Guillett]

or something like this maybe if c11 is a number
=IF(ISNUMBER(c11),VLOOKUP(c11,A1:E4,E11+1),"")

 

[Guest]

It appears to me that you haven't specified a result in the event E11 does
not equal 2 or 3.

=IF(E11=2;VLOOKUP(C11;Taux;3);IF(E11=3;VLOOKUP(C11;Taux;4),"place here"))