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
|