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

two way lookup and cell reference
 

Detat,

Generally:

=INDEX(DataTable,MATCH(DesiredStockName,ColumnOfNa meLabels,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


"Detat" wrote in message
...
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

two way lookup and cell reference
 

Thanks Bernie!!!

that put in me in the right direction.

Cheers


"Bernie Deitrick" wrote:

Detat,

Generally:

=INDEX(DataTable,MATCH(DesiredStockName,ColumnOfNa meLabels,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


"Detat" wrote in message
...
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