Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use vlookup for tax tables state and fed
how do i use vlookup for tax tables state and/or fed
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use vlookup for tax tables state and fed
I believe it will be a double-lookup sort of issue. Take a look at this:
http://www.contextures.com/xlFunctio...ml#IndexMatch2 Found this via Google: http://en.allexperts.com/q/Excel-105...-formula-1.htm Finally............. http://j-walk.com/ss/excel/usertips/tip020.htm Regards, Ryan--- -- RyGuy "VLOOKUP" wrote: how do i use vlookup for tax tables state and/or fed |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use vlookup for tax tables state and fed
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 "VLOOKUP" wrote: how do i use vlookup for tax tables state and/or fed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup Tables | Excel Worksheet Functions | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
VLOOKUP with TABLES | Excel Discussion (Misc queries) | |||
VLookUp Tables | Excel Worksheet Functions |