Lookup Value from one worksheet to another

I am having problems transferring data from one worksheet to another using the LOOKUP Function.

I have one worksheet where there are two columns: team and points. I sorted the worksheet by team and used the subtotal function to get a Team Total. So now the team column has the teams names and the inserted field TEAM total with the next column showing the total of points.

I am trying to transfer the total number of points on to my other worksheet. I used the Lookup function on the worksheet where the team information is and It worked. However I cannot figure out how to insert this formula on the worksheet I am trying to get the total value to.

This is the function I used: =LOOKUP("RED TEAM Total", c2:c31, d2:d31) this worksheet is named TeamTotals. I am trying to insert this onto the summary worksheet named summary. How do I do this? I tried inserting on the summary page the lookup function but cannot figure out where to put the worksheet reference (TeamTotals!).

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?

Thank you! Much easier! Problem Solved!!

On My team totals page I import three columns of info: Name, rank and team. I have a fourth column points. I then sort by rank and assign points to the top 30 only. 1st = 30, 2nd=29, etc until i reach position 30. all others below that get a 0. I have been doing this manually, what would be an easier way so I could set up all the worksheets prior and then just import the data? What function would work?