Basically I need a tool to aid in quoting jobs.
I have a table (simplified version attached) that has been populated behind the scenes and gives different quote prices based on two critea - the amount of colours used in the job (Columns) and the quantity of units ordered as there are different price breaks the more units ordered.
What I need is a separate spreadsheet that references this table. I want to be able to simply add in the known critea of a job in two separate cells i.e Quantity customer is ordering, let's say 150 units and how many colours the job is let's say 1.
In this example I would like the equation to reference the table - understand that 150 units falls between the range 150 - 249 and hence uses row 9 and that it is just one colour hence it reference column D the answer then being cell D9 or $23.60