Software

General discussion

Gravatar
Locked

Excel Data Validation drop-down list

By alf25 ·
Hi I'm new to this so I apologize in advance if I don't ask my question in the correct way.
I'm using Excel 97 and I've created a data validation drop down list to be use in column A the actual list resides in column AZ.

The drop down box in column A works fine but I need to automatically assign a numeric value in a separate column for the item selected in column A.

For example if I select BLUE in cell A1 the number 10 will automatically be placed in D1. Select RED in A10 the number 20 will be placed in D10. Essentially I want to assign an ID number for each item in column AZ. I'VE looked in FAQ but I haven't found the answer. Can someone help?

Hope this makes sense.

Thank You

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

by dryflies In reply to Excel Data Validation dro ...

use the function VLOOKUP.
you will need to put your selections in sorted order and put the number in an adjacent column
AZ BA
Blue 10
Red 20
Green 30
in D10 put:
=VLOOKUP(A10,$AZ$1:$BA$3,2,FALSE)

please rate my answer

gravatar
Collapse -

by alf25 In reply to

Poster rated this answer.
Thank you! This is exactly what I needed.

gravatar
Collapse -

by alf25 In reply to Excel Data Validation dro ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Start or search

Related Forums