# Validation List Associated Values

This is a discussion on Validation List Associated Values within the Excel Questions forums, part of the Question Forums category; Thanks all for the help so far. Now I need to know, if I create a form with drop down ...

1. Thanks all for the help so far. Now I need to know, if I create a form with drop down lists ceated from the data/validation path, can I associate a value to each particular selection? Then can I calculate an overall value based upon the various selections?

2. On 2002-06-19 09:54, Ckoehler1961 wrote:
Thanks all for the help so far. Now I need to know, if I create a form with drop down lists ceated from the data/validation path, can I associate a value to each particular selection? Then can I calculate an overall value based upon the various selections?
Why not? You could use VLOOKUP to retrieve from a table the value associated with the selection made from the dropdown list.

3. On 2002-06-19 09:54, Ckoehler1961 wrote:
Thanks all for the help so far. Now I need to know, if I create a form with drop down lists ceated from the data/validation path, can I associate a value to each particular selection? Then can I calculate an overall value based upon the various selections?
Aladin got in before me, to expand a little try something like:

 Microsoft Excel - Book1 ___Running: xl2002 XP : OS = Windows 98
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp
 J2J3J4J5J6J7J8J9J10J11J12J13J14 =

F
G
H
I
J
1
Lookup*Table*Data*ValidationValue
2
ListItemValue*Ian33
3
Ian11*Ian77
4
Ian22*Ian77
5
Ian33*Ian44
6
Ian44*Ian1414
7
Ian55*Ian22
8
Ian66*Ian55
9
Ian77*Ian55
10
Ian88*Ian88
11
Ian99*Ian77
12
Ian1010*Ian66
13
Ian1111*Ian11
14
Ian1212**69
15
Ian1313***
16
Ian1414***
17
Ian1515***
 Sheet1 *

To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

This code was graciously allowed to be modified: by Ivan F Moala All credit to Colo

Hope this helps

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•