Lookup Value from one worksheet to another

Thank you! Exactly what I was trying to accomplish with the LOOKUP Function. I just cant seem to understand the VLOOKUP.

On my team point worksheet there are multiple entries for the same team so that is why I sort it then use the subtotal function.

If I used the VLookup I wouldn't need to sort and subtotal the points to achieve the same result?