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