Need Formula Help Please!

[George]

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.

 

[Lars-Åke Aspelin]

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,"xxx"))

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