Code number

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

When using drop down boxes under the Data:Validation menu,
is there a way of having 2 columns; one that has a
description and one that has a code number ? So you are
prompted by the description but only the code number ends
up in the cell
 
You could use a formula that returns the number based on the description chosen.

If your descriptions/numbers were in Sheet2!$a$1:$b$99, you could use this
formula:

=if(a1="","Please select your choice",vlookup(a1,sheet2!$a$1:$b$99,2,false))

Then use that cell with the codes in them in other formulas????
 
Back
Top