Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a term in cell F2. I'm trying to use that term to return a value from
a cell in a different row and column. I have the INDEX/MATCH formula that will find the same term from column A (A922). So I can get the cell(F2) to find the contents of the INDEX/MATCH. Where I am stumped is trying to get the formula to lookup the term and then return a certain value from a cell that is 4 rows down and 15 columns right (Cell O926). I know I can make a formula to find the exact contents of that cell. That's not what I need. What I need is a generic formula so that I can change the contents of cell F2, the formula will find the contents in column A, and then lookup the value 4 rows down and 15 columns right. It has a certain piece of information I need. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding specific text in one cell and returning data from another | Excel Worksheet Functions | |||
Returning same value cell in a column but different row. | Excel Worksheet Functions | |||
finding the cell with min value and returning the contents of neig | Excel Worksheet Functions | |||
Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
finding cell value in another column and returning a true or fals | Excel Worksheet Functions |