View Single Post
  #4  
Old May 4th, 2005, 10:27 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default

Use a lookup table

=VLOOKUP(A1, H1:L12,2,FALSE)

--
HTH

Bob Phillips

"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?