Solved

Populating based on data in two columns

Posted on 2016-08-26
3
53 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:paxtonm
  • 2
3 Comments
 
LVL 29

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 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:paxtonm
ID: 41772322
Very quick response and excellent communication!
0
 
LVL 29

Expert Comment

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

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

770 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