I have a list of consecutive dates in row 3:3.

In column J I will enter dates.

I would like a formula that takes the date I have entered in column J (eg.
J9) and searches row three for the matching date and then returns the value
in row 4 in the same column.

For a similar problem I used a combination of INDIRECT and MATCH.

=INDIRECT((MATCH(I9,3:3,0))&"4")

the problem is that match returns a numerical position instead of a column
letter. is there any way to convert a number to a coresponding letter? or
just a formula that will do what i want?

=INDEX(4:4,1,(MATCH(I9,3:3,0)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ellebelle" wrote in message
...
I have a list of consecutive dates in row 3:3.

In column J I will enter dates.

I would like a formula that takes the date I have entered in column J (eg.
J9) and searches row three for the matching date and then returns the
value
in row 4 in the same column.

For a similar problem I used a combination of INDIRECT and MATCH.

=INDIRECT((MATCH(I9,3:3,0))&"4")

the problem is that match returns a numerical position instead of a column
letter. is there any way to convert a number to a coresponding letter? or
just a formula that will do what i want?