Hi Fran,
Take a look at Debra web

http://www.contextures.com/xlFunctions03.html

if this helps please click yes, thanks

"Fran" wrote:

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?