Lookup,Compare,Equate?

[Krefty]

Good Day and thanks for looking at my problem. I am going
to check on this every few minutes so that I can quickly
respond to any questions that any eager helper is eager to
help me with this.

I have a workbook with a worksheet named "reglist". In
this "reglist" I have 800+ regs that have many differant
brands. I will use this example to continue to explain.

B2 is the "Plant Number" this is a unique identifier to
every group, this "Plant Number" identifies the location
of the specific reg.

F2 = Reg 1 Make --Example (FISHER)
G2 = Reg 1 Model --Example (630)
H2 = Reg 1 Size --Example (2)

I need to create a new column or another worksheet that
takes each B2 line then looks at F@,G2 and H2.

Within the workbook I have created another worksheet for
each brand, this example is Fisher and the name of the
worksheet is "Fisher". On this worksheet

A2 - Make -- Example (FISHER)
B2 - Model-- Example (630)
C2 - Size -- Example (2)
E2 - Cg -- Example (6.82)

My desire is to have a function or macro, I am not sure I
am not great at working the Excel magic like others, that
allows me to create an additional column on the "reglist"
or create another worksheet that allows me to populate a
column with pressure so in this example we will use 100
for 100% I need each B2 "Plant Number" to lookup ((MATCH
UP)) based on Make, Model and Size then when or however it
locates its match by matching "Make" with the
proper "Make" worksheet in this example the worksheet that
it is looking for is "Fisher" it then takes the Cg factor
from E2, or the matching "E" column as it needs to be the
same size and model as the "reglist" worksheet of that
woksheet and creates the eqation 1.29((B2)(100)).

I hope that I was able to explain this well enough that
you can help me to create this function that I can cut -
and - paste directly into a cell and work with the
solutions. Please email me if you have any questions or
additional needed data.

Thanks in Advance...

Krefty

 

[wiseman]

As you have not had a reply to this I have given it a go, but I am not sure
it is what you need.

In sheet 'reglist' I put this in A2 (which I think was blank)
=F2&"."&G2&"."&H2
This gave me
FISHER.630.2
Then in sheet FISHER I put this formula
=A2&"."&B2&"."&C2
which gave me the same.
Then in I2 of 'reglist' I put this formula to return 6.82
=INDEX(FISHER!E:E,MATCH(A2,FISHER!H:H,FALSE))

But I am not sure where the 1.29 comes from or what B2 is or the 100 do you
want to multiply B2 by something and which B2 would that be?

Barbara

 

[Guest]

Barbara thanks for taking a look at this I really do
appreciate it.
I have been trying to solve this for weeks. The 1.29 is a
constant, it exists as a standard multiplier always, no
matter what Cg from the "Fisher" worksheet returns. For
every Make, Model, Size that the "reglist" has "Fisher"
has a specific Make,Model, Size that will match up. The
key is that for each Make,Model,Size that matches up it
will have a specific (Cg factor) this is E2 of
the "Fisher" worksheet once the Make,Model,Size match up,
A2 of the "reglist" could match up with B26 of
the "Fisher" again the key is to have the correct
Model<Make<Size find the right (Cg Factor) in your
provided example ((6.83)) is the correct (Cg) now I need
that Cg=6.83 multiplied by 1.29 then again multiplied by
the 100 to solve for FLOW. The 100 would represent a
pressure that I can put in manually. Lets use column AA
of "reglist" for a manual pressure entry, Because
sometimes I might only want to equate on 50psig.

Again, Thank You and Thank You I think that you are closer
than I have been in weeks I just can't see the solution.
I will check back again soon if you might have any further
questions.

Krefty