Three Condition Excel Tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2201031%22%20slang%3D%22en-US%22%3EThree%20Condition%20Excel%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2201031%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20working%20with%20Remuneration%20tables%20and%20am%20wondering%20if%20there%20is%20an%20elegant%20solution%20to%20finding%20a%20value%20if%20three%20factors%20are%20known.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EABCDE%2C%20T%2C%20I%2C%20II%2CIII%2C%20IV%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20I%20would%20be%20after%20the%20value%20that%20is%20attached%20to%3A%20B%2C%20T%2C%203%26nbsp%3B%20%26nbsp%3B%26gt%3B%20100%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20an%20EXCEL%20file%20for%20reference%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2201031%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2201530%22%20slang%3D%22en-US%22%3ERe%3A%20Three%20Condition%20Excel%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2201530%22%20slang%3D%22en-US%22%3EUnable%20to%20realize%20the%20issue%20you%20are%20facing%20with%2C%2C%2C%20since%20you%20have%20value%20from%20Row%203%20to%207%20but%20how%20to%20get%20these%20values%20and%20what%20you%20need%20to%20to%20further%20wuth%20them%2C%2C%2C%20if%20any%20calculation%20the%20write%20all%20about%20it!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2201641%22%20slang%3D%22en-US%22%3ERe%3A%20Three%20Condition%20Excel%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2201641%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F993676%22%20target%3D%22_blank%22%3E%40GlennM1960%3C%2FA%3E%26nbsp%3BI%20believe%20what%20you%20ask%20for%20is%20in%20the%20attached%20sheet.%20Note%20that%20the%20formula%20in%20B15%20is%20in%20its%20roughest%20form.%20That%20is%2C%20using%20direct%20cell%20references.%20You%20can%20make%20it%20easier%20to%20read%20and%20maintain%20if%20you%20would%20give%20meaningful%20names%20to%20the%20cell%20ranges%20references%2C%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

So working with Remuneration tables and am wondering if there is an elegant solution to finding a value if three factors are known.

 

ABCDE, T, I, II,III, IV

 

so I would be after the value that is attached to: B, T, 3   > 100

 

I've attached an EXCEL file for reference 

5 Replies
Unable to realize the issue you are facing with,,, since you have value from Row 3 to 7 but how to get these values and what you need to to further wuth them,,, if any calculation the write all about it!!

@GlennM1960 I believe what you ask for is in the attached sheet. Note that the formula in B15 is in its roughest form. That is, using direct cell references. You can make it easier to read and maintain if you would give meaningful names to the cell ranges references, though.

Riny,

A very elegant solution , thank you very much
Thank you a nice elegant solution.

@GlennM1960 You're welcome!