Make a list of your 12 options in one out of the way column, then in the
next column to the right, put your corresponding values you want to show up
for each option.......say this is done in X1:Y12

Then if your "first" cell is A1, put this formula in B1

=VLOOKUP(A1,X1:Y12,2,FALSE)

Vaya con Dios,
Chuck, CABGx3


"rlb" wrote in message
...
Hello. I need help with what I thought was a simple "If, Then" type of
function. I would like to use functions to fill information in another
cell.
My problem is that the first cell has a possibility of 12 different
options
which would then result in a value. (So 12 options = 12 different
values.)
Is this possible or can you tell me how to accompish this task?