Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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))) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |