Not sure which you're looking for, so I'll provide 2 answers to your question.

If you only want column B to equal the value in column A
in cell B2, type:
=A2

If you're saying you have a value in A2, and, let's say you have another
worksheet with the same value as A2, with a corresponding variable in, say,
F2, then:
=VLOOKUP(A2,sheet1!A:F,6,FALSE)
will look for your A2 value on sheet2 of your workbook in column A and
return the value in column F. (the 6 refers to the column #, F is the 6th
colun from A - F). FALSE is there so that you will only get a corresponding
value if cell A2 is found in column A of the new table.

"jason2444" wrote:

want to know if it is possible to write a formula that will check one column
for specified variables and depending on the variable fill in a seperate
column with the text assigned to that variable

like if column A1 contains the words Chevy,Chevrolet then put the word Chevy
in A2 or if contains the words dodge then put the word dodge in A2.