benjamin Rolliston
New Member
- Joined
- Aug 3, 2007
- Messages
- 2
I've created a drop down menu in E1, what i am try to do is link F1 & G1 to the selection i make from the drop down in E1. The example i've given is from A6, B6 & C6. So if i selected Ub-150-14 (A1) from the drop down list (E1) i want 0.58 to appear in F1 and 14.00 in G1. Can some one please show me the steps required to do this. It's driving me mad!
Ultimate Quota.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | UB-150-14 | 0.58 | 14.00 | UB-180-18 | 0.69 | 18.10 | |||
2 | UB-150-18 | 0.58 | 18.00 | ||||||
3 | UB-180-16 | 0.68 | 16.10 | ||||||
4 | UB-180-18 | 0.69 | 18.10 | ||||||
5 | UB-180-22 | 0.69 | 22.20 | ||||||
6 | UB-200-18 | 0.76 | 18.20 | ||||||
7 | UB-200-22 | 0.91 | 22.30 | ||||||
8 | UB-200-25 | 0.91 | 25.40 | ||||||
Data |