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