In cell drop down menu with seprerate numerical target cell

[Remco]

Hi,

I'm hoping for some assistance on the following...

I've created an in-cell dropdown menu with two options, lets call them
"ABC" and "XYZ". these two options are listed in the drop down menu but
i would like to attach values to those options which should appear in a
different target cell.

My list is inserted on the fields A1 and A2. the values attached to
those names can be found in B1 and B2. the dropdown menu can be found
in cell A5 and the target cell for the value matching the input in the
dropdown menu is B5.

E.g. one would select from the drop down menu: "ABC". In that case the
value belonging to ABC (so cell B1) should appear in cell B5. when one
would select "XYZ" the value of B2 should appear in B5.

Is there some one who can help me out?

Besides the two options I want to insert a third blanc option with
value 0, but I guess that's not influencing the solution

Regards,
Remco

 

[smw226 via OfficeKB.com]

Hi Remco,

It should be as simple as

=IF(A1="",0,A1) where A1 is the actual cell with the drop-down

HTH

Simon

Hi,

I'm hoping for some assistance on the following...

I've created an in-cell dropdown menu with two options, lets call them
"ABC" and "XYZ". these two options are listed in the drop down menu but
i would like to attach values to those options which should appear in a
different target cell.

My list is inserted on the fields A1 and A2. the values attached to
those names can be found in B1 and B2. the dropdown menu can be found
in cell A5 and the target cell for the value matching the input in the
dropdown menu is B5.

E.g. one would select from the drop down menu: "ABC". In that case the
value belonging to ABC (so cell B1) should appear in cell B5. when one
would select "XYZ" the value of B2 should appear in B5.

Is there some one who can help me out?

Besides the two options I want to insert a third blanc option with
value 0, but I guess that's not influencing the solution

Regards,
Remco

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200610/1

 

[Jim May]

In your cell B5 enter:

=VLOOKUP(A5,$A$1:$B$2,2,FALSE)

HTH