1. ## 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. ## Re: Adding up Vlookup (XP)

Hi Karat,

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

3. ## 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. ## 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. ## 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. ## Re: Adding up Vlookup (XP)

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

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