I have set up a simple spreadsheet to identify the numbers of days to deliver a product. Cell A2 contains a product. Cell B2 contains an order date. Cell C2 contains the formula =WORKDAY(B2,2). This works fine but what I would like to do is produce a dropdown menu in A2 to allow me to pick a product and for the formula in C2 to adjust according to the product
Product date ordered delivery date
Battery 02/06/2014 04/06/2014
In the example above a battery takes 2 days to deliver but a torch might take 8 days to deliver. How can I get the C2 formula to adjust depending on product.
Bookmarks