SOLVED

VLookup that then multiplies based on answer?

%3CLINGO-SUB%20id%3D%22lingo-sub-2625009%22%20slang%3D%22en-US%22%3EVLookup%20that%20then%20multiplies%20based%20on%20answer%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625009%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20construct%20a%20VLookup%20table%20that%20will%20take%20the%20amount%20in%20B16%20(Taxable%20Income)%20and%20figure%20out%20where%20in%20the%20Flat%20Tax%20Rate%20table%20that%20amount%20falls%20in%2C%20then%20multiply%20the%20B16%20cell%20by%20the%20correct%20%25%20Rate.%20So%20G16%20*should*%20be%20%2413%2C330%2C%20but%20I%20cannot%20for%20the%20life%20of%20me%20figure%20it%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2625009%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2625056%22%20slang%3D%22en-US%22%3ERe%3A%20VLookup%20that%20then%20multiplies%20based%20on%20answer%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625056%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120891%22%20target%3D%22_blank%22%3E%40KScott85%3C%2FA%3E%26nbsp%3BTry%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DB16*LOOKUP(B16%2CE6%3AE10%2CG6%3AG10)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2625442%22%20slang%3D%22en-US%22%3ERe%3A%20VLookup%20that%20then%20multiplies%20based%20on%20answer%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625442%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThat%20100%25%20worked%2C%20thank%20you%20again!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I'm trying to construct a VLookup table that will take the amount in B16 (Taxable Income) and figure out where in the Flat Tax Rate table that amount falls in, then multiply the B16 cell by the correct % Rate. So G16 *should* be $13,330, but I cannot for the life of me figure it out.

2 Replies
best response confirmed by KScott85 (Occasional Contributor)
Solution

@KScott85 Try this:

 

 

=B16*LOOKUP(B16,E6:E10,G6:G10)

 

Or, since you tagged you post with Office365, this one should work for you as well.

=B16*XLOOKUP(B16,E6:E10,G6:G10,"",-1)

 

@Riny_van_Eekelen That 100% worked, thank you again!