Thread: VLOOKUP
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
roadkill
 
Posts: n/a
Default 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)))