Re: pricing problems

will you be using measurements that match the measurements on your pricing
*** or will you want the lookup to use the next largest measurement??say
your actual measurement is 32 but the next closest price measurement is 36(i
assume you wouldnt want to go to the smaller measurement of say 30)
--
paul
remove nospam for email addy!



"paul" wrote:

> thats ok,as long as each product/work*** has a unique name.I am in NZ so i
> will respond tonight(our time)Watch this space!!!!
> --
> paul
> remove nospam for email addy!
>
>
>
> "trent" wrote:
>
> > yes, but there are a total of 38 different products.
> >
> > "paul" wrote:
> >
> > > so every product has its own unique specific work*** name?
> > > --
> > > paul
> > > remove nospam for email addy!
> > >
> > >
> > >
> > > "trent" wrote:
> > >
> > > > thank you for responding. I hope this is what you are requesting.
> > > > EXAMPLE of pricing ***:
> > > > wood shutters
> > > > 12" 18" 24" 30" 38"
> > > > 12" 152 185 192 201 245
> > > > 18" 185 215 255 301 299
> > > > 24" 192 255 295 345 397
> > > > 30" 201 264 315 396 425
> > > > 38" 245 301 345 425 526
> > > >
> > > > this example is on a *** labeled 'wood shutters' in workbook labeled
> > > > 'pricing', from another workbook labeled 'Our Costs' we are wanting to input
> > > > the type of product (so to reference the 'price' ***) then the width
> > > > (indicating the column headings) and the height (indicated by the row
> > > > headings) to give us a result. Example:
> > > >
> > > > PRODUCT WIDTH X HEIGHT PRICE
> > > > wood shutters 18 x 30 reference from wood shutter ***
> > > > vinyl shutters 21 x 32 EXAMPLE '345'
> > > > etc. 15 x 32 EXAMPLE '301'
> > > >
> > > > the example above shows in the product column we have vinyl shutters also
> > > > listed. We would like to have a scoll down box to include all products that
> > > > we have pricing sheets for, so that when we select a specific product it
> > > > would reference the respective pricing ***.
> > > >
> > > >
> > > > "Bernie Deitrick" wrote:
> > > >
> > > > > Trent,
> > > > >
> > > > > Post a couple example tables, along with the cell range addresses where they
> > > > > are entered, and it will be easier to help you.
> > > > >
> > > > > Bernie
> > > > >
> > > > >
> > > > > "trent" <trent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > > > news:6B7E56C1-EEB9-4CE0-8AAB-480393EC38EA@xxxxxxxxxxxxxxxx
> > > > > >I need to enter a PRODUCT TYPE, WIDTH and HEIGHT for Window coverings. I
> > > > > >have
> > > > > > pricing grids, but i do not know how to link the grids to another form
> > > > > > where
> > > > > > i input the product type, width, height. I want the product to find the
> > > > > > grid
> > > > > > that matches, then on that grid i need the width to go to the column that
> > > > > > matches (type in 36 and it goes to the column of 36-42), then the height
> > > > > > to
> > > > > > go to the row that matches its measurements? Can anyone please help me on
> > > > > > this?
> > > > >
> > > > >
> > > > >
.