Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup a value and return its cell reference instead of the value | Excel Discussion (Misc queries) | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Lookup numbers in sheet and assign it's cell reference | Excel Discussion (Misc queries) | |||
Cell Reference with Range Name | Excel Worksheet Functions | |||
Return cell reference of lookup value | Excel Worksheet Functions |