| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find a value in an array and return cell address
I need to be able to find a text value in an array and have it return the
cell address. For example, I would need for find 'Sprint' somewhere in A1:AZ100. Some months it could be in A1, others it cound be in AA90. It would only appear once. If it appears in cell A1 I want the result of the formula to be A1. Can this be done? Thanks! PJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
| Find Max in array- return corresponding cell | Excel Worksheet Functions | |||
| Return Cell Address of MIN value - array formula | Excel Worksheet Functions | |||
| Array Formula to find Average Return | Excel Discussion (Misc queries) | |||
| Find max number of character and return cell address | Excel Worksheet Functions | |||
Threaded Mode
