In my google worksheet, I'm trying to find the number of shots on target for Crystal Palace. As you can see, in the Fixtures sheet, cell D2, I am using VLOOKUP to bring the data I need from the SOT sheet. In my example, I want cell D2 to read 19, which is the total number of shots on target recorded by Crytal Palace.
I'm guessing I need to include the SUM function but I'm still not having any luck coming to the correct solution.
https://docs.google.com/spreadsheets...it?usp=sharing
Thank you.
Bookmarks