| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you lookup a value & get the cell reference?
I have a workbook with two sheets. I am trying to look up a value in cell A1
of Sheet 1 in colum A through C of Sheet 2. When it finds the value, I want it to return a reference to the cell where it was found (or somehow tell me where it was found). I could reduce my search to just column A of Sheet 2, but I would prefer not to since there are some cases were the value is in column C. I have not been able to find a lookup function that returns a reference. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup a value and return its cell reference instead of the value | Excel Discussion (Misc queries) | |||
| Reference Cell Color From Other WorkSheets | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
Threaded Mode
