View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default 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