# Lookup in table

1. ## 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.

3. ## Re: Lookup in table

worksheet name : Withholding

Cell E6 formula

Formula:
`Please Login or Register  to view this content.`

4. ## Re: Lookup in table

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

5. ## 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

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

#### 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