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