how to use vlookup for tax tables state and fed

[VLOOKUP]

how do i use vlookup for tax tables state and/or fed

 

[ryguy7272]

I believe it will be a double-lookup sort of issue. Take a look at this:
http://www.contextures.com/xlFunctions03.html#IndexMatch2

Found this via Google:
http://en.allexperts.com/q/Excel-1059/Formulating-correct-formula-1.htm

Finally.............
http://j-walk.com/ss/excel/usertips/tip020.htm



Regards,
Ryan---

 

[Shane Devenshire]

Hi,

=VLOOKUP(A1,TaxTable,2,TRUE)

Where A1 contains the taxable income, the range, here called TaxTable is a 3
column table with taxable income in the first column sorted in ascending
order, columns 2 and 3 containing the tax for single or married. 2 tell you
which column applies to you 2 or 3. A two would mean you are single. True
mean that you are doing an approximate match. Which is what you want in a
tax situation. Substitiute the range where your tax table is for TaxTable in
my formula.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire