use Vlookup function



On Apr 16, 6:21*pm, dlb1228 wrote:
i have a column with race information in it *for example

black * * 1
white * *2
asian * *3
white * *2

i would like to calculate the field next to it to a number for example *if
its black then put a 1 in the cell, or white = 2, asian = 3