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...
|