Hi all,

This is probably a really simple fix but would be great if someone could explain where I've gone wrong.

I'm having problems with VLOOKUP - I think it's doing the right thing here (i.e looking at the right data) but it isn't counting all the data with 'Bill & Ben' as a reference it just gives me either 1 or 3 as an answer instead of 9 that the answer should be. See manually put in data for the exact.

Book2.xlsx

Please can someone fix this minor problem for me?

Ben