VLOOKUP SUM multiple values...

[PPMIKE]

Hi All,

Apologies if this question has been asked already!

I am having trouble with the vlookup as it's only taking the first value it finds in the list.

All i want to do is to vlookup a value based on a unique ID (made up of a country&date) and match this same Unique ID on another tab to pull in the totals, though it's only pulling in the 1st one it finds!

I'm using this right now and it doesnt work

=SUM(IFERROR(VLOOKUP(I9,'Online Data'!$A:$F,8,0),"-"))


would really appreciate any advise.

Thanks,

[samba_ravi]

USE SUMIF FUNCTION Otherwise attach a sample excel file

[Ace_XL]

You need SUMIF

=SUMIF('Online Data'!$A:$A,I9,'Online Data'!$F:$F)

Adjust ranges accordingly

[Pete_UK]

The table you have defined in the VLOOKUP function is only 6 columns wide, but you are trying to return data from the 8th column, so it is bound to return an error. Use SUMIF, as others have suggested.

Pete

[PPMIKE]

Ive attached my file. Im still struggling =(

Really grateful for all the quick responses Im getting, you guys are ace!

[JohnTopley]

Try

IGNORE se next post

[JohnTopley]

=SUMIF('Online Data'!$A:$A,I9,'Online Data'!$F:$F)

[PPMIKE]

Thanks for that, i tried the formula but it pulling int he same values as before unfortunately

[JohnTopley]

The SUMIF works: my other post was in error.

[PPMIKE]

Yes! It works now John.

Thanks so so much, you don't know how much this actually has helped me =)

Cheers to everyone else, and have a merry xmas all

[JohnTopley]

To be fair you were given the solution in posts #2 and #3!

Merry Christmas to you.

[JohnTopley]

If SOLVED can you please mark as such ("Thread Tools" at top of first post)