Vlookup under condition

[goble]

Hello Excel Gurus,

I have sheet 1:

Date Invoiced	Name	Date Planned	Include in report	Location
01-Aug-23	Event 1	01-Dec-23	Yes	New York
01-Sep-23	Event 2	12-Dec-23	No	Las Vegas

& sheet 2:

Date Invoiced	Name	Description	Date Planned	Include in report	Location
15-Aug-23	Event 3	Fun Day	08-Nov-23	No	Miami
22-Aug-23	Event 4	Wedding	15-Nov-23	Yes	Seattle

The result I would like, sheet 3 :
Note:
1. So seems I need to combine a VLOOKUP if data is 'Yes' in 'Include in report' column
2. 'Date planned' should appear in the first column

Date Planned	Name	Location
15-Nov-23	Event 4	Seattle
01-Dec-23	Event 1	New York

 

[goble]

Hello,

Seems like VLOOKUP won't do the job because of several occurrences of 'Yes'. Maybe using the 'MATCH' formula ?

 

[awoohaw]

There is probably a formula that can do what you need but would be fairly lengthy. But, have you considered doing this in Power Query.
There are many tutorials on Youtube that descibe taking data from tables/sheets/other workbooks of differing structure and combining.
The Youtube channels of Mr. Excel, ExcelIsFun, Leila Gharani, and MyOnlineTrainingHub all have a video and even playlists on Power Query.
Here is a link to MyOnlineTrainingHub's playlist on Power Query.

https://www.youtube.com/playlist?list=PLmd91OWgLVSKnVrL0YxdOH61MAiqlFHac