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