Creating a pricing table - with 2 input fields.
 

Ive created a pricing matrix, width of item along the top, height of item
down the side - with all the different prices inbetween. How do I go about
creating a separate quotation sheet where the user fills in box 1 (width of
item), fills in box 2 (height of item) and excel refers to the table and
automatically tells him the price.

Hope this makes sense.

Nige.

Creating a pricing table - with 2 input fields.
 

One possible solution requires understanding 2 different formulas. Vlookup
and Match. It would be used something like this...

=VLOOKUP(A9, A2:G7, MATCH(A10, B1:G1, FALSE) + 1, FALSE)

Working with this table
A B C D E F
A 1 7 13 19 25 31
B 2 8 14 20 26 32
C 3 9 15 21 27 33
D 4 10 16 22 28 34
E 5 11 17 23 29 35
F 6 12 18 24 30 36

Place B in cell A9 and E in Cell A10 the formula returns 26...

--
HTH...

Jim Thomlinson


"Big Bad Nige" wrote:

Ive created a pricing matrix, width of item along the top, height of item
down the side - with all the different prices inbetween. How do I go about
creating a separate quotation sheet where the user fills in box 1 (width of
item), fills in box 2 (height of item) and excel refers to the table and
automatically tells him the price.

Hope this makes sense.

Nige.

Creating a pricing table - with 2 input fields.
 

Sorry, Im lost - Ive tried to recreate what you said, but i couldnt get it to
work ???? Is there any way of setting up an example field that i can grab or
can you send me one via email ?

"Jim Thomlinson" wrote:

One possible solution requires understanding 2 different formulas. Vlookup
and Match. It would be used something like this...

=VLOOKUP(A9, A2:G7, MATCH(A10, B1:G1, FALSE) + 1, FALSE)

Working with this table
A B C D E F
A 1 7 13 19 25 31
B 2 8 14 20 26 32
C 3 9 15 21 27 33
D 4 10 16 22 28 34
E 5 11 17 23 29 35
F 6 12 18 24 30 36

Place B in cell A9 and E in Cell A10 the formula returns 26...

--
HTH...

Jim Thomlinson


"Big Bad Nige" wrote:

Ive created a pricing matrix, width of item along the top, height of item
down the side - with all the different prices inbetween. How do I go about
creating a separate quotation sheet where the user fills in box 1 (width of
item), fills in box 2 (height of item) and excel refers to the table and
automatically tells him the price.

Hope this makes sense.

Nige.