| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return the value in a cell at the intersection of a row and a colu | Excel Discussion (Misc queries) | |||
| Intersection point return data | Excel Worksheet Functions | |||
| Return Text In Cell realting to Max Value in different colum | Excel Discussion (Misc queries) | |||
| sumif to return an intersection? | Excel Worksheet Functions | |||
| If it's not a space, return the cell contents. | Excel Worksheet Functions | |||
Linear Mode
