Complicaded Drop down list

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

Guest

Is there any way of having a drop down list such as the following:

System count wrong
Customer requested more than we normally stock
Out of stock
Item not on L.I.T.E list
Not a normal stock item for your branch
Vendor Supply Problem

but when ones of these are selected for a corresponding value show up in
place of it. As per following

100 = System count wrong
200 = Customer requested more than we normally stock
300 = Out of stock
400 = Item not on L.I.T.E list
500 = Not a normal stock item for your branch
600 = Vendor Supply Problem
 
I think I'd use an extra cell (directly to the left of the cell with the
dropdown).

And I'd build a separate worksheet that had the descriptions in column A and the
number codes in column B.

If that dropdown is in B1, then I'd put this in A1:

=if(b1="",vlookup(b1,sheet2!a:b,2,false))
 
Back
Top