Auto fill from pick list
Hi Biff, not quite, let me explain better.
Cell E23 is a drop down list which uses a VLOOKUP to fill in H23 & J23
e.g. E23=CHEP then H23=1200, J23=1000
E23=Euro Then H23=1000, J23=800
Cell F26 is another drop down with either Short or Long as the options.
This should auto fill G33 & G34 with whatever is in H23 & J23
If E23=CHEP (user pick)
H23=1200 (auto)
J23=1000 (auto)
If F26=Short then G33=1200 G34=1000
But if F26=Long then G33=1000 G34=1200
Andy
|