I am Pete, and I'll be happy to answer your Excel question today.
This can be achieved using the VLookup function.
I have edited your Excel file and uploaded it here: http://wikisend.com/download/239666/Gallons yoy2.xlsx
ok, I don't know how to open the file
any ideas? it has a bunch of files in the zip
I did download it
cool, for whatever reason it was saving at .zip I change it to .xls and it works great