Variable Value Function Help?

[Jonathan Cheek]

Here is what Im trying to do. In cell B2 I have List Validation that has
a source of: "Local Buy, Mass Media Buy". In cell A2 I want the value to
change based on what i choose in cell B2. What I'm aiming for is when i
select "Mass Media Buy" in Cell B2 then I want Cell A2 to =B14 and when I
select "Local Buy" in cell B2 I want cell A2 to =B19.
I have tried using SUMIF, LOOKUP, and nested IF Functions, none of them
seem to work for what Im coming up with. I know it is possible, but my logic
is faulty with this issue.
Any suggestions?

 

[cm]

in cell A2:

=IF(B2="Mass Media Buy",B14,B19)

this assumes there is at least one choice. otherwise, you will specify what
you want a2 to be if neither buys are selected (this one puts a zero for no
selection):

=IF(B2="Mass Media Buy",B14,IF(B2="Local Buy",b19,0))

 

[Jonathan Cheek]

Thanks allot this really helps. I didn't know you had to put the text in
quotations.