Cool Buddy
Wise Old Owl
I often have to make lists of some items which is like a quotation for the buyers. I have all the items and their prices listed in a separate sheet. For the name of the items i use drop down menu. Is there any way so that the price is taken automatically in the cell on its right?