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