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
|