VLOOKUP
 

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

VLOOKUP
 

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


"Ann" wrote in message
...
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)))

VLOOKUP
 

Maybe...

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

Ann wrote:

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

--

Dave Peterson

VLOOKUP
 

This might simplify for you:

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

HTH
Owen


Dave Peterson wrote:
Maybe...

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

Ann wrote:

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

--

Dave Peterson

VLOOKUP
 

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

--
Don Guillett
SalesAid Software

"Dave Peterson" wrote in message
...
Maybe...

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

Ann wrote:

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

--

Dave Peterson

VLOOKUP
 

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

"Ann" wrote:

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