convert number to letters

[ellebelle]

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?

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ellebelle" <[email protected]> wrote in message
news:[email protected]...
> 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?