| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP on 2 sets of criteria
My data set looks something like this.
Test Name Level Spec Test 1 8 -32 Test 1 9 -32 Test 1 10 -32 Test 1 11 -34 Test 1 12 -34 Test 2 8 -28 Test 2 9 -29 Test 2 10 -31 Test 2 11 -32 Test 2 12 -32 I would like to be able to do a VLOOKUP on Spec, based on a combination of TestName AND Level Is this possible? Thanks sandy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with 4 sets of criteria to match? | Excel Worksheet Functions | |||
| IF FUCTION WITH 2 SETS OF CRITERIA | Excel Worksheet Functions | |||
| Vlookup for 2 sets of Criteria (or do I need to use something else | Excel Discussion (Misc queries) | |||
| vlookup with 2 sets of criteria | Excel Discussion (Misc queries) | |||
| SUMIF with two sets of criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
