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.

On Thu, 29 Jan 2009 11:39:01 -0800, George
wrote:

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.

Try the following formula in cell B4:

=IF(B3="David",Sheet2!E2,IF(B3="Ken",Sheet2!E3,"xx x"))

Sheet2 is the sheet name of your "next page".
xxx is what you get if cell B3 is neither David nor Ken.

Hope this helps / Lars-Åke