View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default Reverse Vlookup?

mark.stevenson418 wrote:

I am searching a table for a known value in a table and would like to
return the column heading and row heading. Each would be in their own
respective cell. From my understanding it might be something along the
lines of a reverse lookup? I can email the excel file upon request.


http://lmgtfy.com/?q=vlookup+backwards

The second result (from extendoffice.com) should be what you're after.

--
We hide from the unspeakable.