| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find and return adjacent value
How would I do the following using a formula:
Find the row that contains value X, then in that row find the cell that contains value Y, then return the value to the immediate right? Example: 111 AAA Todd Tim 222 ABB Tony Tom 333 BBB Sue Shelly x=222, y=Tony, returned value = Tom Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search and return adjacent value | Excel Discussion (Misc queries) | |||
| Return adjacent cell if conditional formatting exists. | Excel Worksheet Functions | |||
| Return value in adjacent cell | Excel Worksheet Functions | |||
| return value in adjacent cell different workbook | Excel Worksheet Functions | |||
| test a range of cells and return an adjacent value | Excel Worksheet Functions | |||
Threaded Mode
