View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Big Bad Nige Big Bad Nige is offline
external usenet poster
 
Posts: 6
Default 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.