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!!!