Vlookup assistance...

Hi...

I am attempting to use Vlookup to automate - at least to a certain extent - a very time consuming football formula I created years ago. I will give a simple example and hopefully someone can show me how to use vlookup to get the info I need. Here is the data and the home team is listed first:

Clemson 32 UNC 7
Duke 7 Clemson 56
UNC 28 Duke 27

I would like to use vlookup to pull information about all three teams. total Wins/losses, total home/away, total point scored/points allowed. Is this possible??? Hopefully the makes sense to someone out there. Thank you!!!

Hi,

The attached example may give you some ideas. I don't think a VLOOKUP is the best way since it only returns one result and therefore precludes multiple occurrences of the same team in a column. The SUMPRODUCT() is much more flexible for something like this. I didn't understand what you meant by points allowed or how you calculate this so I've not included that.

HTH

Awesome... That was the missing link!!! I just didn't know that function... Thanks a bunch!!!