| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
look up table values with multiple conditions
I have a fairly basic table of bolts and their attributes...
A B C 1 SIZE LENGTH STRENGTH 2 .5 1/2 100 3 .5 3/4 150 4 .75 1/2 150 5 .75 3/4 200 Cell D6 is an input cell for size, cell D7 is an input cell for strength, Cell D8 is the resultant lookup I want to do a vlookup(?) that finds the correct length based upon BOTH size (D6) AND strength (D7). I am sure there is a way to do this but I am used to only having one variable to do the vlookup with. =vlookup(D6, A1:C5, 2) where the result is =D7 (How do I do this?) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique values - Pivot Table | Excel Discussion (Misc queries) | |||
| Count unique values - Pivot Table | Charts and Charting in Excel | |||
| how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Multiple table lookup | Excel Discussion (Misc queries) | |||
Threaded Mode
