Quotation from a pricing data base

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?

Originally Posted by Leith Ross

Hello comgames,

Welcome to the Forum!

Check out how to create and use row and column labels on a worksheet. By using the row label and column label in a formula, you can return the value of the cell where they intersect.

Thanks for that, I will give it a try.