VLOOKUP

A

Ann

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)))
 
B

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)
 
O

Owen

This might simplify for you:

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

HTH
Owen
 
D

Don Guillett

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

roadkill

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"))
 
Top