Hi,
Is it possible to dynamically look up a value based upon matching a a date column heading?
e.g.
Sheet 1
---Jan---Feb---March---April
x---1-----2-------3------BLANK--
y
z
Sheet 2
---Jan---Feb---March---April
Q--1-----2-------3-------3---
Thus i'm trying to achieve a formula that can match column heading (date) on one sheet with column heading on another, then look down that column to find a value.
However as a twist on this, I need it to be able to use the last "completed" value should the match not exist or the value is blank.
In the above example, on Sheet 2 I would like Aprils value for "Q" to use March's value from Sheet 1 as the look up returns a null value.
Would really appreciate any help with this little problem.
Thanks
DM
EDIT: Typo
Bookmarks