?
Solved

Populating based on data in two columns

Posted on 2016-08-26
3
Medium Priority
?
70 Views
Last Modified: 2016-08-26
I'd like to be able to answer 'GB Taken' with a "Yes or No" and populate the date based on matching last name and first name on sheets 'Yellow Belt' and 'Green Belt'.
PaxtonTest.xlsx
0
Comment
Question by:Michael Paxton
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 32

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 2000 total points
ID: 41772038
Try this....

On Yellow Belt Sheet
In C2
=IF(ISNUMBER(MATCH($A2&$B2,INDEX('Green Belt'!$A$2:$A$5&'Green Belt'!$B$2:$B$5,),0)),"Yes","No")

Open in new window

and copy down.

In D2
=IFERROR(INDEX('Green Belt'!$D$2:$D$5,MATCH($A2&$B2,INDEX('Green Belt'!$A$2:$A$5&'Green Belt'!$B$2:$B$5,),0)),"")

Open in new window

and copy down.

For details, refer to the attached.

PS. Set the Calculation Options to Automatic which is set to Manual right now.
PaxtonTest.xlsx
0
 

Author Closing Comment

by:Michael Paxton
ID: 41772322
Very quick response and excellent communication!
0
 
LVL 32

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41772628
Thanks for the feedback.
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question