Search code examples
excelms-officeexcel-2003office-2003

Excel 2003 Combobox/Validation Data List Values and Labels

I'm unable to find out this information: Is it possible to show labels in these two type of lists rather than the real values ? of course when a label is selected, the value of the cell or the combobox (as a Form control) gets the real value.

Example: * Data Product A <------> 10 Product B <------> 11 Product C <------> 22

Combobox shows: Product A, Product B and Product C If I select A I get the 10 value, B the 11 value and C the 22 value

Thank you in advance

Miloud B.

Solution

  • The typical way of doing this is to have a lookup table. There's a function named something like VLOOKUP (that's a partial name) that you can use in formulas to retrieve the value. I did something like this at my job, and I created a lookup table in a separate spreadsheet, and then called the lookup function in my main one.

    You can also use macros, but that is too much bother in my opinion for the current problem.