Aug 08 2021 07:51 AM
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.
Aug 08 2021 08:02 AM - edited Aug 08 2021 08:05 AM
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)
Aug 08 2021 12:35 PM - edited Aug 08 2021 02:08 PM
@Riny_van_Eekelen That 100% worked, thank you again!
Aug 08 2021 08:02 AM - edited Aug 08 2021 08:05 AM
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)