View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fran Fran is offline
external usenet poster
 
Posts: 19
Default Excel 2003 - Lookup type of question

I want to lookup and return the cell (on a different spreadsheet) where the
Row Header and the Column Header Match...... If A50 and Colum ZZ were both
named Orange, I want to return THAT specific cell into a spreadsheet.....
Orange in the column header and Orange on the road header - BRING ME THE
CELL.....

What formula or lookup type thing do I use?