Any help with this would be extremely helpful as this is driving me mad! I
produce weekly statistics on individual/team performance that are extracted
via SQL but need to attribute a value to show the team that each person works
in. This is currently a manual process and I am trying to automate this to
speed things up. This is using Excel 2000.

What I have is a range of cells with more than one individual name (X,Y and
Z) and need to write a formula that defines what the next cell should be
populated with (Team 1, Team 2 or Team 3 etc). The formula would therefore
want to say that if A1 is X or Y or Z then A2 should be populated with the
name Team 1 or Team 2 or Team 3 (having attributed the name of the Team to
the respective individual within the formula).

I hope that I have explained this ok but please respond if you want to
clarify anything.

Cheers

David

Probably mis-understanding, but

=IF(A1="X","Team1",IF(A1="Y",Team2",IF(A1="Z","Tea m3,")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David Platt" <David wrote in message
...
Any help with this would be extremely helpful as this is driving me mad! I
produce weekly statistics on individual/team performance that are
extracted
via SQL but need to attribute a value to show the team that each person
works
in. This is currently a manual process and I am trying to automate this to
speed things up. This is using Excel 2000.

What I have is a range of cells with more than one individual name (X,Y
and
Z) and need to write a formula that defines what the next cell should be
populated with (Team 1, Team 2 or Team 3 etc). The formula would therefore
want to say that if A1 is X or Y or Z then A2 should be populated with the
name Team 1 or Team 2 or Team 3 (having attributed the name of the Team to
the respective individual within the formula).

I hope that I have explained this ok but please respond if you want to
clarify anything.

Cheers

David

Worked a treat Bob, thankyou very much!

"Bob Phillips" wrote:

Probably mis-understanding, but

=IF(A1="X","Team1",IF(A1="Y",Team2",IF(A1="Z","Tea m3,")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David Platt" <David wrote in message
...
Any help with this would be extremely helpful as this is driving me mad! I
produce weekly statistics on individual/team performance that are
extracted
via SQL but need to attribute a value to show the team that each person
works
in. This is currently a manual process and I am trying to automate this to
speed things up. This is using Excel 2000.

What I have is a range of cells with more than one individual name (X,Y
and
Z) and need to write a formula that defines what the next cell should be
populated with (Team 1, Team 2 or Team 3 etc). The formula would therefore
want to say that if A1 is X or Y or Z then A2 should be populated with the
name Team 1 or Team 2 or Team 3 (having attributed the name of the Team to
the respective individual within the formula).

I hope that I have explained this ok but please respond if you want to
clarify anything.

Cheers

David