View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Detat Detat is offline
external usenet poster
 
Posts: 2
Default two way lookup and cell reference

Hi

I think that this has been asked before, but i can't find the answer.

I need to find the cell reference from a two-way lookup (think a table of
daily stock prices over a year, and then i want a particular stock's price on
a certain day).

The data are in a different workbook.

I've been stuck on this for a while now.

Greatly appreciate any advice.

Cheers