| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A function that looks for a value on a sheet on unknown column or row
How can I make a function that looks for a value on a sheet, on unknown column or row, and returns row and column position where it found it. I presume it has to be done using MATCH in an array formula that searches entire columns from 1 to 255 and ISNA to ignore the unmatched columns, and ADDRESS to inform the cell found... I've been trying unsuscesfully to assemble it and make it work... Thanks. Paul. -- Paul134 ------------------------------------------------------------------------ Paul134's Profile: http://www.excelforum.com/member.php...o&userid=31735 View this thread: http://www.excelforum.com/showthread...hreadid=516275 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Naming column in Index Function | Excel Worksheet Functions | |||
Threaded Mode
