Excel - Conditional results -

[KiwiRiccardo]

Right, what I am trying to do is this.

Data is already in Excel.

I have 30 users that each process transactions that have their user name attached.

each user belongs to one of five teams.

I need a new column that shows the team that a user belongs to based on their name.

I have been playing with nested IF statements and have something that works up to the five names that I have done so far but this seems really cumbersome.

Cheers

KiwiRiccardo
Can anyone help????

 

[bluedragon2]

Have a table with usernames in one column and team in the next column.

In the field you want the team name, do a vlookup for an exact match.

Blue

 

[SkipVought]

Hi,

On a new sheet enter a column fo names and a column of the name's related team.

Then on your original sheet a new column for team with formula

=VLOOKUP(A1,NewSheet!A$1$:B$30$,2,False)

assuming that A1 contains the first name and NewSheet is the name of your new sheet...

and copy down

VOLA!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ETID]

Use the vlookup function

the following is general syntax


=vlookup(name_cell_ref,absolute_ref_of_lookup_list,2)

...the 2 assumes that your lookup list has 2 columns and that names are in col 1 and team is in col 2

 

[KiwiRiccardo]

bluedragon2, SkipVought, ETID, Thanks for your help on this one. So easy when you know how!!