Dynamically lookup value based upon column heading (date)

D

DangerMouse

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
 
Top