Populate list [Closed]

Report
-
Hello,
I'd like to scan a column for a certain word (e.g. "Yes") within particular date in workbook, and i need to copy the text in some other cell for that particular date into the summary sheet.

For Example:

A B C D
1 Apple 10 6/2/2016 Yes
2 Mango 11 6/1/2016 No
3 Orange 12 6/1/2016 No
4 Banana 13 6/2/2016 Yes

I need to choose "Yes" from D row and only for 6/2/2016 i need to get A Column data

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!