| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search and return adjacent value
I have a file as follows
3010,123456789,4103,123.56,5101,123 3010,987654321,3011,abcde,4103,15000.00,5103,654 3010,654987321,4103,4523.69,5104,987 I need to search for the value 4103 and return the value after it eg. 123.56 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i referance an adjacent cell from a search? | 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
