Good Day and thanks for looking at my problem.  I have a
list of 806 locations within my business and I need to
calculate a "flow" total using LOOKUP or IF functions to
create a calculation.

I have roughly 15 company's that I use as a "make"
manufacture for Reg 1 Make, Reg 2 Make and RV Make.  I
need to create something like a macro or querie function
that upon opening or forcing a manual running of that
macro,  says. IF (plant/location) this breaks up the 806
locations.

(lookup reg 1 make) When reg 1 make = "Mooney" (The name
of this will have to change to meet the 15 differant
manufactures)

Then (lookup) and solve the equation for Mooney (In this
case or for this maufacture it is (1.29 Cg P1)

Cg and P1 are specific factors that I have in electronic
version and whcih Cg is used is based on "size" and body
class.  This is in the same table of the "make"
and "plant/location".

After re-reading this it does seem very confusing but if
you could help me set up some equations or lookup or
macro functions I would greatly appreaciate it.  Or if
you know of any links that you could give me to help me
solve this I would greatly appreciate it.

Thanks in ADVANCE.

Krefty