| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning the cell reference when you find a value in an array
Hey folks! I've scoured the Excel help documentation, and I haven't found
anything that can solve my problem here. Say I have a table that looks like this: A B C 1 Ed John Kim 2 Tim Joe Sue 3 Al Ann Zoe What I need is some formula where I say, "What cell contains 'Sue'?" and it would return "C2". Any ideas? Thanks! -Taylor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
| Returning a cell reference with a formula? | Excel Worksheet Functions | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| Returning with cell on right/left of a reference | Excel Worksheet Functions | |||
| How can I use a cell reference in Sumproduct array formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
