| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel to input fields into a Word Form | Excel Worksheet Functions | |||
| Pricing from a table based on dimesions in 2 differnt cells (Excel | Excel Discussion (Misc queries) | |||
| Pull recent pricing data from table | Excel Worksheet Functions | |||
| Input one criteria to search in 5 fields | Excel Discussion (Misc queries) | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
