I am creating an invoice with multiple areas that each have a different price for each item. I would like to be able to select from the drop down and use vlookup to look up the description and amount for the area selected in the drop down from another sheet. Can anyone help?
So what I would like to be able to do is where it says Emergency Invoice Area: In the drop down menu, when N03B is selected and I move down to Unit and description to use vlookup i want it to pull the prices from the sheet labeled N03B. The same goes for each area.