Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Lookup Calculation
I need to combine the following lookup statements, if it finds the value in
the first look-up I want to use that number. If the number does not exzist in the first look-up, then I want it to use the swecond look-up (in which the number will always be found). Here are my 2 look-up statements in the proper order. =vlookup($D15,shrinks,6,false) =vlookup($D15,stores_ty_pl,20,false) I appreciate your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation on lookup | Excel Worksheet Functions | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Excel lookup and calculation | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |