In Excel 2007, I am trying to enter a formula to do the following;
When I enter a person's name in cell B3, I would like cell B4 to show the
total of a cell on a different page.
ie. if cell B3 = David, then cell B4 should equal the sum of cell E2 from
the next page. If I change the name from David to Ken, I need cell B4 to
equal the sum of cell E3 from the next page.