About Us

David Platt

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Look up function for multiple criteria	DEE	Excel Worksheet Functions	2	November 21st 06 07:00 PM
MULTIPLE CRITERIA RETURNING SUM OF RESULTS	[email protected]	Excel Worksheet Functions	0	November 15th 06 05:11 PM
Using Sumproduct Function To Add Multiple Criteria	Ange Kappas	Excel Worksheet Functions	1	January 23rd 06 11:29 AM
Multiple criteria LOOKUP	Leon	Excel Worksheet Functions	2	December 22nd 05 01:13 PM
Multiple Criteria IF Nesting	BethB	Excel Worksheet Functions	2	May 17th 05 12:14 AM

Menu

About Us