One way:

In the second column use a formula that references the first column. In
your example, if the value "Math1" is entered in cell A2, use the formula

=A2

in the other column


"michael M" wrote:

we need that users will enter same exact values in 2 different colums. the
reson being is that the spreadsheet data is uploaded to DB. later on a
program checks that values in each column are matching in order to permit the
request.
if the user enter "Math1" in one column but "Math 1" in the second column,
the program will deney his request.
i am wondering if there is a way that typing values in one column will allso
fill up same values on a different column?