# Thread: VLookup Woe (Excel 2000)

1. ## VLookup Woe (Excel 2000)

I took my problems with Code in Previous Problem I sent in and decided on Vlookups for tax tables instead. I have one problem left that is bothering me with it. Could someone take a look at this worksheet? In Cells M57 and M65 I have given to comments on formulas placed there. The Federal S works fine I believe, but the Federal M is working horrid. I feel the answer should be 120.50 if it works just like the Federal S does, and it should...but keeping getting 454.75 for an answer. Appreciate any advice.
Thank you.

2. ## Re: VLookup Woe (Excel 2000)

The first lookup in the formula looks for the first value in column of FedM that is less than the search value from V4. This is 535 (in cell G62)
The second lookup looks for the corresponding value in the fifth column of FedM. This is also 535 (in cell K62)
The third lookup returns the corresponding value in the fourth column of FedM, i.e. 15% (in cell J62)
The fourth lookup returns the corresponding value in the third column of FedM, i.e. 0 (in cell I62)
The formula evaluates to 535 - 535 * 0.15 + 0 = 535 - 80.25 + 0 = 454.75
If this is not what you intended, the formula for both married and single persons is wrong. Please check carefully what you wanted to calculate.

3. ## Re: VLookup Woe (Excel 2000)

Will take a second look, Thank you Hans
Nannette

4. ## Re: VLookup Woe (Excel 2000)

Look over <post#=331498>post 331498</post#>. I outlined this "vlookup procedure" for you in an earlier thread.

Steve

#### Posting Permissions

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