How to set up: If cell X =1, value is A, if cell X =2, value is B
 

Cell A1 could have one of 12 values. Each of those values is associated with
one of 12 values listed in Column D. How do I get Cell A1 to know which value
to pick out of Column D?

How to set up: If cell X =1, value is A, if cell X =2, value is B
 

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"snowsaw" wrote in message
...
Cell A1 could have one of 12 values. Each of those values is associated
with
one of 12 values listed in Column D. How do I get Cell A1 to know which
value
to pick out of Column D?

How to set up: If cell X =1, value is A, if cell X =2, value is B
 

How do the values in column D correspond to those entered in column A? Can
you give an example?



"snowsaw" wrote:

Cell A1 could have one of 12 values. Each of those values is associated with
one of 12 values listed in Column D. How do I get Cell A1 to know which value
to pick out of Column D?