Variable Value Function Help?
 

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?

Variable Value Function Help?
 

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))
--
hope to help,
cm


"Jonathan Cheek" wrote:

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?

Variable Value Function Help?
 

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

"cm" wrote:

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))
--
hope to help,
cm


"Jonathan Cheek" wrote:

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?