Return the contents of a cell at the intersection of row and colum
 

I have a table in a sheet called "Pay_Table" in which there are grades in
column A and steps in row 1.

I need to do a lookup in another sheet that finds and returns the
intersection of a particular grade and step. For example, Lookup Grade 8 and
Step 5 and return the contents of that cell.

What formula can I use to do that?

Thanks much in advance...

Return the contents of a cell at the intersection of row and colum
 

This seems to work...

=INDEX(A1:I13,1+MATCH("Grade 8",A2:A13,0),1+MATCH("Step 5",B1:I1,0))

Adjust each of the Column I and Row 13 references to match your set up.

Rick


"XP" wrote in message
...
I have a table in a sheet called "Pay_Table" in which there are grades in
column A and steps in row 1.

I need to do a lookup in another sheet that finds and returns the
intersection of a particular grade and step. For example, Lookup Grade 8
and
Step 5 and return the contents of that cell.

What formula can I use to do that?

Thanks much in advance...