require a bit of clarification

  • Thread starter Thread starter Maclear
  • Start date Start date
M

Maclear

Kay,

I checked out what those address and offset functions do. And I'm no
sure that they do what I want. I apologize if my first post wa
unclear.

Basically, I buy raw materials, the prices depend on the quality of th
material, the weight bought at once, and the state of origin. My price
are arranged in a 2D table. Weights are on the y-axis and quality o
the product is on the x-axis. For each unique combination of a give
weight and level of quality comes a unique price.

But given weights and quality are held constant, the price will stil
vary if the product comes from a different place. So I have severa
worksheets with a 2D price table on each of them. All worksheets hav
the exact same shape and structure. So I just need the program to pic
the right table according to the "state of origin value".

Okay, that was just to make sure I explained what I'm trying to d
properly...

Now, as I said, I m not quite sure what those address and offse
functions do, rather I know what they do separately cuz' I checked i
out, but I don' t understand how they will work together. Could yo
please develop a little bit further on the mecanism of your formula.

Thanks for your help by the way, I appreciate
 
Okay my bad,

It's very late, and I have a tendency to mix things up like, fo
instance, "post a reply" and "new thread".

Maximum apologies !:
 
Back
Top