I have 1 workbook with massive data. My common identifier for all data is a full name (G2).
I'm searching the sheet based on one identifier (G2), but the value of that identifier is present multiple times in the worksheet because many reports have been run for this name; therefore, I'm only looking specifically for the date of one specific report with a cleared status that has been completed within 30 days of its launch date.
I need to find a specific date in column X based on these 5 criteria:
G2: identifier. "Name of person". It is present multiple times in other areas of the report.
O2: start date of report.
X:X - the completion dates of all reports. The date I'm isolating out of column X has to be more than O2 but less than o2+30 days.
AD:AD - report name. I need "On*"
W:W - report status. I need "Complete"
I've tried:
index,match
Iferror,Ifs,lookup
Index,sumproduct,row
Iferror,if,countif,vlookup
None of these formulas, the way I've written them, work. Any help is appreciated!