I have a range, E5:J748. I want to use a vlookup that will find the
first instance of the value in cell W5 (which is '06G271') and the
value in cell H5 (which is 'Steady State') occuring in the same row
together within the range E5:J748. So it looks for the two values in
W5 and H5, searches for the first row within E5:J748 that they occur
together and then returns the value in cell J5 as the lookup which in
this case is 'BRC'. I have no idea how to use a vlookup, or modify a
vlookup to accept two lookup values as criteria for the lookup. Any
ideas how?

Thanks,

Tom