two way lookup and cell reference

[Guest]

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

 

[Bernie Deitrick]

Detat,

Generally:

=INDEX(DataTable,MATCH(DesiredStockName,ColumnOfNameLabels,False),MATCH(DesriedDate,RowofDateFields,
False))

or the reverse, depending on which you have (Dates or STocknames) down the col vs across the row.
Just make sure that your column, row , and datatable coincide.

When you create the formula, just have the other workbook open, and select the ranges as required.

HTH,
Bernie
MS Excel MVP

 

[Guest]

Thanks Bernie!!!

that put in me in the right direction.

Cheers