In a Data Validation cell, I need to have a value for each item. If they pick "Digital Media" in E3 then the value would be 1.50. The items associated with the cell are (=Sheet2!A1:A14).
How is this done?
How is this done?
You're the best Jason.So the dropdown is in E3? If so then in F3,
=VLOOKUP(E3,Sheet2!$A$1:$B$14,2,0)
Note that it will return 0 if E3 contains 'Other'. If you overtype the formula with a value when that happens, the formula will be gone unless you re-enter it again afterwards. It will not be replaced automatically next time you change the dropdown.
Are you saying if K3="YES" then N3 should be $8.20 (in the example)?In K3 I need to add .20 per sqft if "YES' is chose (=Sheet2!$D$1:$D$3) the cell that contains "YES" is D2.