So I would like to update the second column (avaliable) with the data from
the date columns automatically on a give day. In this instance on 12/5 the
avalible column should be A=25, B=37, C=44, D=39, E=35,F= 22

on 12/6 the values should auto update to A=24, B=36, C=42, D=38, E=34,F= 21


Redmond
Test Available 12/3 12/4 12/5 12/6 12/7
A 22 12% 38 25 25 24 23
B 33 19% 58 39 37 36 35
C 39 22% 67 45 44 42 40
D 35 19% 60 40 39 38 36
E 31 17% 54 36 35 34 32
F 19 11% 34 23 22 21 20
Goal 179 309.96 208.46 201.21 193.96 186.71

I don't see where the automatic update feature would factor into your
equation. I Probably didn't explain myself very well.
--
Jeff


"vezerid" wrote:

Jeff,
I assume your date and contributor lookup values are in K1 and L1
respectively. I further assume that your table occupies the range
A2:F10 and that date headings appear in row 2 as you indicate in your
post. Change as necessary.

=VLOOKUP(L1, A2:F10, MATCH(K1, A2:F2, 0), 0)

HTH
Kostis Vezerides