| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to lookup data in cell NEXT to another cell
I have downloaded some historical quotes for MSFT in one spreadsheet. IN
another sheet I want to write a formula to say find June 19, 2009 and look for the previous TRADING DAY (not previous day, which could be a weekend day). How do I do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup - result (cell) shows formula, not lookup data | Excel Discussion (Misc queries) | |||
| Using a cell with a formula in it for lookup value | Excel Worksheet Functions | |||
| Lookup vertically to next cell with data | Excel Worksheet Functions | |||
| Formula to lookup cell value | Excel Discussion (Misc queries) | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
