| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value of one cell a certain number of cells away from another cell
I've seen this function but just can't find it again.
How do I get a cell to take the value of a cell 2 cells to the left of a cell with a specific value. For example, I want a cell to take the value of a cell 2 cells to the left of a cell with a unique text string. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Value of one cell a certain number of cells away from another cell
Is it all column based, so does this work for you
=INDEX(C:C ,MATCH("string",E:E,0) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Box815" wrote in message ... I've seen this function but just can't find it again. How do I get a cell to take the value of a cell 2 cells to the left of a cell with a specific value. For example, I want a cell to take the value of a cell 2 cells to the left of a cell with a unique text string. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Hybrid Mode
