if else with character

**anujteetwal** · 01-13-2012, 10:16 AM

how to replace character by the numeric no.

i have a list of color ,i want to when someone chose the color name ..it show its designated Numerical No...
like this.

color name color code
Red 1
Blue 2
Black 3
white 4
new green 5
pink 6
orange 7
dark green

thanks in advance

**NBVC** · 01-13-2012, 10:17 AM

You can use VLOOKUP

e.g.

If list is in X1:Y10 and user enters colour in A2, then formula would be:

=VLOOKUP(A2,$X$1:$Y$10,2,FALSE)

See VLOOKUP help in Excel help files for more.

**Andrew-R** · 01-13-2012, 10:18 AM

If your colours are in column A and the numerical values in column B, with the selected colour in, say, cell C1 then in another cell try:

=VLOOKUP(C1,A:B,2,FALSE)