Assign number to list items in drop down box

July 10, 2010 at 12:39:21
Specs: Windows XP
Hello. How to assign a number to text. I have a drop down box and i want to assign different numbers to each of the list item in that drop box. For example i have Annual,semi;annual, quaterly in my drop down box and i want to assign them 1. 0.5,ond 0.25 respectively. please help me

See More: Assign number to list items in drop down box

Report •

#1
July 10, 2010 at 14:18:34
Hi,

If the list used for the drop-down is in cells C1, C2 & C3
Enter the value in cells D1, D2 & D3
for example C1="Annual", D1=1

If your drop-down list is in Cell A1,
enter this in cell B1:
=VLOOKUP($A$1,$C$1:$D$3,2,FALSE)

B1 will now contain the 1, 0.5 or 0.25 based on what has been selected in A1.

You could of course embed the VLOOKUP() function in another formula, so that the formula can use the values directly.

Regards


Report •
Related Solutions


Ask Question