Let me see if I got this correct. In column B rows 1 through 26 you have AA,
AB, AC, ect...
In the same row, but in column C, you want a "Y" to appear when it matches
what's in A1?

If that is what you want, then in C1 you could use:

=IF(A$1=B1,"Y","")

Then copy this formula down through row 26.
If this is not what you were looking for, then please elaborate.

Paul


"RemySS" wrote in message
...
PCLIVE, galimi

yes, B2 could also be blank, which would be the case if there was nothing
in
the cell A1. However, could i use the formula provided in a different way,
say if cell A1 could be anything from AA to AZ?

E.g. Column B2 would hav a list of AA-AZ and in the column next to it a Y
could appear depending on what value is entered in cell A1. so if A1 has
"AA", Y would be populated in the column (C) next to the cell in column B
where AA should be listed, and the same for the others?

p.s., thanx for the initial formula!

Galimi, Could you elaborate a bit more on your solution? thanks



"galimi" wrote:

You can use a sheet change event to determine when the contents of cell
a1
have changed. You can then determine the results and populate the other
cells according to the results.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"RemySS" wrote:

Hey all,

Does anyone know the code to auto-populate cell B1 with a "Y" if cell
A1 has
"AA" in it, and cell B2 with a "Y" if cell A1 has "AB" in it? The cells
in
column A could have anyhting between AA and AZ, but the corresponding
column
B will always have a "Y" depending on which letters are in column A.
Make
sense?! Sorry if its rather ambiguous, I'm crap at VBA and could use
the help!