I am in sales, when I visit a client to give them a quotation on any number of items I use the following...

a) I have a pricing spreadsheet (Spreadsheet #1) that lists dollar amounts based on the size of the item in question; you take the width and look across the chart, take the height and look down, where they meet gives you a dollar amount...

b) I have a 'quotation' spreadsheet (Spreadsheet #2) that I type in the item description, colour, quantity etc. and I type in the size of the item; unfortunately, I then have to manually refer to Spreadsheet #1 for the dollar value. The quotation spreadsheet then automatically calculates the rest...

I would like, when I type in the sizes (that are the reference to the Pricing spreadsheet) to have the dollar amount automatically appear where I have previously had to enter manually.

Can you please help?