Hi
try
=INDEX('data'!A1:AX100,MATCH(4,'data'!A1:A100,1),MATCH(3,A1:AX1,0))
and replace 4 and 3 with some cell references

Signature
--
Regards
Frank Kabel
Frankfurt, Germany
> Need Help!
>
[quoted text clipped - 11 lines]
> My goal is to first find a match contained between "Start" and "End"
> column values on this Data sheet (above) by entering a desired
number
> (on different Master sheet). This is relatively easy (using
> VLOOKUP)...
[quoted text clipped - 6 lines]
>
> Also entered on the Master sheet is a desired number for columns
headed
> 1 thru 150... based on this number and a number that is found during the
> VLOOKUP (within the Start and End columns)... I want to extract the
> corresponding number under the Cloumns headed 1 - 150.
>
> I.E.
> - Since the first example above was a value of 4 found between 1 and
5
> in Row 1 (Class 1), and if the desired column value of 3 is also
given,
> the answer I want back is 10.00.
> - In the 2nd example, if 12 and 2 are given, I need to get back 15.25
[quoted text clipped - 10 lines]
> SCW's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1188
> View this thread: http://www.excelforum.com/showthread.php?threadid=266754