I think you are going to have to tell us more about Row 1 between Columns B
and Y. Is the updated date that is entered there **always** going to be the
latest of any of the dates in that row? If not, is there anything about the
entry that would make it "stand out" so we can identify it?

Rick


"Bahareh" wrote in message
...
Hello
I am trying to create a formula which can look up to find data on a raw
and
returns the value on the same column on another raw. Here is the outline
of
the table:
A B C D ......
Y

1 3-Aug

2 pj.Month Az Dy Es ...... Ab

3 Month 11/7 12/7 1/21 .... 12/21

4 forcats 36 91 151 ...... 217

5 Adjusted forcasts 70 180 200 ..... 217

6 Actual T.Cum 24 47

7 Actual N.Cum 11 16

8 =INDEX($A$1:$Y$7, MATCH("Actual T.Cum",$A$1:$A$7,),
MATCH(DATEVALUE("2008/08/02"),$A$1:$Y$7,))

The formula is created by Lookup wisard but as you see, a problem exist in
the second MATCH function which have to be updated manually every day
within
DATEVALUE function! We actually use formula to get ride of manual updating
but here I have to update the formula daily to find the date which has
been
updated on row 1 (which might be in column B to Y and might be today date
or
another date).

Please kindly help me to improve the above formula to lookup the updated
date in row 1 and returns the row 6 in the related column.

Great Appreciation previously!
Thanks