ListBox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to use a selection from a list box A5 to populate a different cell in D5. My list box has four selections TPO 1, TPO 2, TPO 3, TPO 4, TPO 5. I want a given dollar amount to post in cell D5. Example if TPO 1 is selcted then D5 will display $3.00, when TPO 2 to is selected D5 will display $4.00..etc...
 
Hi
Add the following function in the cell where you want the
amount to display
=LOOKUP(A5,RangeTPO,RangeAmt)
where A5 is where the list box is addee.
RangeTPO is range of cells where TPO 1, TPO 2 and so on
are kept.
RangeAmt is range of cells where amounts are kept.
-----Original Message-----
Trying to use a selection from a list box A5 to populate
Click to expand...
a different cell in D5. My list box has four selections
TPO 1, TPO 2, TPO 3, TPO 4, TPO 5. I want a given dollar
amount to post in cell D5. Example if TPO 1 is selcted
then D5 will display $3.00, when TPO 2 to is selected D5
will display $4.00..etc...
 
As it is only four you can use IF

=IF(A5="TPO 1",3,IF(A5="TPO 2",4,IF(A5="TPO 3",5,6)))

or an inline lookup

=VLOOKUP(A5,{"TPO 1",3;"TPO 2",4;"TPO 3",5;"TPO 4";6},2,FALSE)

or if the amounts are single 1 step up, even

=MATCH(A5,"{TPO 1","TPO 2","TPO 3","TPO 4"},0) + 2

The target cell will need to be formatted.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

ncinelli said:
Trying to use a selection from a list box A5 to populate a different cell
Click to expand...
in D5. My list box has four selections TPO 1, TPO 2, TPO 3, TPO 4, TPO 5. I
want a given dollar amount to post in cell D5. Example if TPO 1 is selcted
then D5 will display $3.00, when TPO 2 to is selected D5 will display
$4.00..etc...
 
Back
Top