Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

excel compare two rows and give value

Hi Experts ,

I have attached an excel sheet .

                  
team a       team b              player
a            a                           shawn
b            c                         david
c            a                           mach
d            b                           rich
e            e                         none
            b                          raj

What i am trying to do here is compare team a to team b and output players related to them.

i.e. if a = a output should be shawn


Plz help
0
santoshmotwani
Asked:
santoshmotwani
  • 4
  • 3
1 Solution
 
jppintoCommented:
You didn't post any attachment...
0
 
jppintoCommented:
Where are the "player" names comming? A second list? It's not clear what you want to do here...please provide a sample sheet.
0
 
Dave BrettCommented:
A simple IF test in the foruth column works, see attached

=IF(A2=B2,C2,"")

Cheers


dave
out.xlsx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
santoshmotwaniAuthor Commented:
sorry i forgot to attach.
question.xlsx
0
 
jppintoCommented:
OK, but what do you want to do here? You need to explain please. Do you want this file to be the source of a check on another sheet and if the criterias of team a and team b is met to return the player name?
0
 
santoshmotwaniAuthor Commented:
if team a and team b is met to return the player name?

thats all i need , its all in one shee
0
 
santoshmotwaniAuthor Commented:
@ brett

nice help mate !!! just one modification , there are two players for a in the sheet ... how to get all of them ...

like something compare a will everything in teamb ....then compare b with everthing in team b


Thnx
0
 
santoshmotwaniAuthor Commented:
thnx mate !!!!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now