| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Question Please
Hello from Steved
We have two people one labels it E2 the other labels it 2 the both are the same product. Can I write in the below formula for it to use either for the formula to identify. Thankyou. $A329 is E2 $A$2 is 2 =VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula Question Please
=IF(ISNA(VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE)),
VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE), VLOOKUP($A32,'From Depot'!$A$2:$O$3955,4,FALSE)) -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Steved" wrote in message ... Hello from Steved We have two people one labels it E2 the other labels it 2 the both are the same product. Can I write in the below formula for it to use either for the formula to identify. Thankyou. $A329 is E2 $A$2 is 2 =VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula Question Please
Thankyou
"Bob Phillips" wrote: =IF(ISNA(VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE)), VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE), VLOOKUP($A32,'From Depot'!$A$2:$O$3955,4,FALSE)) -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Steved" wrote in message ... Hello from Steved We have two people one labels it E2 the other labels it 2 the both are the same product. Can I write in the below formula for it to use either for the formula to identify. Thankyou. $A329 is E2 $A$2 is 2 =VLOOKUP($A329,'From Depot'!$A$2:$O$3955,4,FALSE) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula question | Excel Worksheet Functions | |||
| Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| formula question | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Hybrid Mode
