deLockloire
Board Regular
- Joined
- Apr 4, 2008
- Messages
- 110
- Office Version
- 365
- Platform
- Windows
Hi,
I have a table. Dates in Column A, values in Column B. I need to lookup the last data from column B for a date given but only if the value is not "" (I populate column B with a formula, and if that formula doesn't find anything, it returns a ""). If there is no data in Column B for the date given, I need the last data which is not "", closest to but less than the date given.
I'm putting this into a cell with a multilayered conditional formula, so I'm just curious what would be the shortest solution to keep the already complex formula as simple as possible.
best,
deL
I have a table. Dates in Column A, values in Column B. I need to lookup the last data from column B for a date given but only if the value is not "" (I populate column B with a formula, and if that formula doesn't find anything, it returns a ""). If there is no data in Column B for the date given, I need the last data which is not "", closest to but less than the date given.
I'm putting this into a cell with a multilayered conditional formula, so I'm just curious what would be the shortest solution to keep the already complex formula as simple as possible.
best,
deL