Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to lookup a value in a list, but return the cell address (or row
number) of where the value was found instead of the value itself. So if my table starts in A1 and looks like this... 3 4 5 6 7 When look up the value of 3 I want to return A1 (or 1). I would use a macro, but that's not an option in this particular case. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Lookup, and Return Cell Address | Excel Worksheet Functions | |||
Use Cell Address Lookup in formula | Excel Worksheet Functions | |||
V Lookup and return cell address | Excel Worksheet Functions |