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
|