Hello all. Forgive me for the vague title. I'm a casual excel user so my nomenclature may be a bit off.
I need a cell to pull a part number based on the results of A8 and C8
A8 is a dropdown (has 3 results).
If A8 is = to A18, then there is no need to proceed.
If A8 is = to A19 or A20, then the result of C8 needs to be taken into account.
C8 is a "roundup" based on an "if" (which includes an Index Match) of B8. This works great.
Together, the results of A8 and C8 (depending on what combo that is) would use Vlookup to get a result (the P/N) for D8
This is for spec'n a transformer for one of our systems.
A8 is the primary power (240V 1ph, 480V 3ph, or 600V 3ph)
B8 is the systems actual kVA demand + 20% [this is taken from another chart which has tons of variables for all the possible power draws]
C8 is a roundup to an actual kVA transformer number (15,30,45,75,etc)
[All of this works, so far]
D8 needs to put the incoming power (A8 result) with the correct kVA transformer (C8 result) to pull the appropriate P/N
If A8 = 240V 1ph, then there is no need for a xfmr.
This will then be referenced in an earlier sheet, to input a $quote, for the project.
My workflow was thinking something along the lines of:
if A8=A18, [true] do nothing, [false] then follow below
if A8=A19 & C8=(C19 or C20 or C21 or C22) , [true] VLOOKUP(C8,C19:D22,2,False), [false] then follow below
if A8=A20 & C8=(C23 or C24 or C25 or C26) , [true] VLOOKUP(C8,C23:D26,2,False), [false] there should be an error
I'm aware that I may be using the incorrect formulas.
Thank you,
-T
Bookmarks