Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Adding up Vlookup (XP)

    Good morning
    I'm trying to convert the standard MS payroll spreadsheet to our New Zealand criteria.
    I have 3 results witht he correct amounts using VLookup. However, now I want to add these 3 amounts together and it gives me a zero result.
    Why is that ???
    Thanks for any help

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

    Re: Adding up Vlookup (XP)

    Hi Karat,

    Without seeing the workbook it's hard to say...

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Adding up Vlookup (XP)

    Spreadsheet attached. Because our tax deductions are very complicated, the user of this sheet will fill out the PAYE box by using the online calculator.

    But why do I have a zero in the Total Gross Pay box.

    I know its always something simple

    Thanks so much

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding up Vlookup (XP)

    Is it because you're trying to add the amounts in column I but your Gross Pay is actually in column H?

  5. #5
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Adding up Vlookup (XP)

    I know it looks silly but in the end I even tried copying the amounts to column I and then adding them up.
    For instance in cell I6 I put =H6. Should have changed that before sending it to you.
    Its odd because I use VLookup often and for some weird and wonderful reason it just wont work.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding up Vlookup (XP)

    Are the circular references intentional? Do have to check the Iteration box in the options?

  7. #7
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Adding up Vlookup (XP)

    Circular reference ?? Not intentional at all
    Surprised excel didn't tell me there were circular references. It usually does...

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

    Re: Adding up Vlookup (XP)

    Sorry, was away from my PC for a while. There is a circular reference in cell 'Payroll calculator'!I13: it refers to F13 and F13 refers to I13. Shouldn't the formulas in Payroll calculator column I be consistent?

    The formula in 'Individual paystubs 4-6'!H9 sums I6 to I8 instead of H6:H8.

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding up Vlookup (XP)

    On Payroll Calculator there are circular references beginning in cell I13. On Individual Paystubs... it says H8 has a circular reference.

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding up Vlookup (XP)

    If you have Iterations checked in Tools>Options on the Calculation tab I don't think it tells you there are circular references...is that maybe what happened for you?

  11. #11
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Adding up Vlookup (XP)

    And it works... Thanks so much for all your help

    Have a great weekend

Posting Permissions

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