I'm working on making a mostly automated invoice sheet for a transport company. I would like to be able to type a work/ choose from drop down in cell D which automatically places a pre assigned value attached to that work in E, while i place a manual value in F and then ExF =g
so for example. I deliver goods to New York for $100 and it weights 1 pounds
so in my destination(D) cell i want to put New York (either type it in or use drop down either is fine) I want (E) to automatically have a value of 100 in which I can manually type the weight of 1 into (F) and then I want to use (G) for E x F =G
ive used a lookup table and a drop down list, which works well however the lookup wont let me do E x F it will only automate the E value
Bookmarks