hi

i need some help if possible. i have a spreadsheet that i have designed for
invoicing. i have a drop down list which i have used data validation for
inputting materials and need the cell next to this to automatically put the
correct price in for each material used. can this be done?