Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLookup Woe (Excel 2000)

    Will take a second look, Thank you Hans
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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
  •