+ Reply to Thread
Results 1 to 5 of 5

Lookup in table

  1. #1
    Registered User
    Join Date
    07-11-2010
    Location
    Goddard, Kansas
    MS-Off Ver
    Office 365
    Posts
    21

    Lookup in table

    I am creating a spreadsheet to figure taxes for payroll. I have the computations for the SS and medicare. I am using the tax table from the irs pub. I need assistance is getting the sheet to lookup the correct value in the table based upon the amount of pay. Here is the table:

    Exemptions 0 1 2 3 4 5 6 7 8 9 10
    $0 $170 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
    $170 $180 $1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
    $180 $190 $2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
    $190 $200 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
    $200 $210 $4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0


    I need it to look between the first and second column and the look to the right based upon the number of exemptions. Example: pay is $185 so it has to look at which line that falls between and then move to the right to the column that has the number of exemptions example 1 exemption which would put it into the second.

    =XLOOKUP(B10,'Tax Table'!A7:B129,XLOOKUP(E3,'Tax Table'!C5:M5,'Tax Table'!C7:M129)) formula I am using but not working.

    Any help is appreciated.

  2. #2
    Registered User
    Join Date
    07-11-2010
    Location
    Goddard, Kansas
    MS-Off Ver
    Office 365
    Posts
    21

    Re: Lookup in table

    Copy of spreadsheet
    Attached Files Attached Files

  3. #3
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    365 & WPS(2022)
    Posts
    2,316

    Re: Lookup in table

    worksheet name : Withholding

    Cell E6 formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-11-2010
    Location
    Goddard, Kansas
    MS-Off Ver
    Office 365
    Posts
    21

    Re: Lookup in table

    Thanks for the reply. Got it figured out with the xlookup function.

  5. #5
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    365 & WPS(2022)
    Posts
    2,316

    Re: Lookup in table

    @takisis666 XLOOKUP is not very familiar to me, at least the formula is written in the correct direction, why can't the result come out, I am wondering

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lookup table help - multiple returns for one lookup value
    By radddogg in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-16-2016, 02:22 PM
  2. How to lookup a value in a table using a range in the lookup columns
    By premis in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-03-2016, 02:47 PM
  3. Replies: 1
    Last Post: 12-19-2014, 02:08 PM
  4. Replies: 1
    Last Post: 06-25-2014, 10:07 AM
  5. Lookup a blank cell in a Lookup table and return a figure.
    By jonnops in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2014, 07:33 AM
  6. [SOLVED] Lookup question matching part of lookup value in the table array
    By kosmo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2013, 11:07 AM
  7. Replies: 0
    Last Post: 08-02-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1