Try this:

...........A..........B
1........X........XB
2........Y........YB
3........Z.........ZB

D1 = Y

=VLOOKUP(D1,A1:B3,2,0)

Result: YB

Biff

"yaheegunsome" wrote in message
...
I have a column that has data A the next column has the data A = data B
When I enter the data from column A I want the data that A = to, to
automatically populate in the next column is this possible?