benjamin Rolliston
New Member
- Joined
- Aug 3, 2007
- Messages
- 2
I'm trying to create a drop down list using Data - Validation that will transfer relevant data (already stored on another sheet) to adjacent cells upon selection from the list. I've been able to put everything listed below in the Materials column into a drop down list but don't know how to link the s/a and kg/m columns to the selection that I make from the list.
The result I’m looking for is, say I select UC-150-23 from the list I want the s/a value (0.89) and the kg/m value (23.40) to appear in the two adjacent columns.
Anyone have the answers?
Material s/a kg/m
UC-100-15 0.56 14.80
UC-150-23 0.89 23.40
UC-150-30 0.90 30.00
UC-150-37 0.91 37.20
UC-200-46 1.18 46.20
UC-200-52 1.19 52.20
UC-200-59 1.22 59.50
UC-250-73 1.48 72.90
UC-250-89 1.50 89.50
UC-310-97 1.79 96.80
UC-310-118 1.81 118.00
UC-310-137 1.82 137.00
UC-310-158 1.84 158.00
The result I’m looking for is, say I select UC-150-23 from the list I want the s/a value (0.89) and the kg/m value (23.40) to appear in the two adjacent columns.
Anyone have the answers?
Material s/a kg/m
UC-100-15 0.56 14.80
UC-150-23 0.89 23.40
UC-150-30 0.90 30.00
UC-150-37 0.91 37.20
UC-200-46 1.18 46.20
UC-200-52 1.19 52.20
UC-200-59 1.22 59.50
UC-250-73 1.48 72.90
UC-250-89 1.50 89.50
UC-310-97 1.79 96.80
UC-310-118 1.81 118.00
UC-310-137 1.82 137.00
UC-310-158 1.84 158.00