General discussion

Locked

Validation in Excel

By jimboom333 ·
If I create a validation drop down list for a cell and then use that list to enter a value in the cell, can I create a formula in another cell to reference a valuefor the inserted validation list info?
Example:
My list for cell B16 contains 4 partnumbers:
EB1
EB2
EB3
EB4

EAch of these part numbers has a specific weight
EB1 100w
EB2 75w
EB3 60w
EB4 50w

When I select EB1 from the list for B16, I would like the associated weight (100w) to show up in cell D16.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Validation in Excel

by DKlippert In reply to Validation in Excel

In D16 enter the formula:

=B16

Collapse -

Validation in Excel

by jimboom333 In reply to Validation in Excel

B16 can only contain the list itself, it cannot include the weight. The weight must be listed elsewhere I suppose and I want it inserted automatically when its corresponding part number is entered in B16.
Entering =B16 will only insert the part number chosen from the drop down list in B16. It will not provide the needed value of the part number.

Collapse -

Validation in Excel

by DKlippert In reply to Validation in Excel

Sorry, I misunderstood. You can use =VLOOKUP()

Create a list of the weights. Let's say from BA1:CA4. The first column is EBx the second column is the weight. To make it easy, select the two columns and use Insert>Name Define to name it "Weights".

The formula would then be:

=VLOOKUP(B16,Weights,2,FALSE)

This looks up the value of B16 in the Weights Table and returns the corresponding value in the 2nd column. The FALSE entry makes sure that the exact entry is returned, but is probablynot needed in this case

Collapse -

Validation in Excel

by jimboom333 In reply to Validation in Excel

Thanks. Your answer has helped tremendously. Can you recommend any technical guides for further reading on the subject?
jim.stanker@candoelec.com

Collapse -

Validation in Excel

by jimboom333 In reply to Validation in Excel

This question was closed by the author

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

Related Discussions

Related Forums