View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
taylor taylor is offline
external usenet poster
 
Posts: 32
Default 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