Forum Discussion
Date Lookup based on multiple columns in separate sheet
Hello all, Hoping someone can support! In the 'Date' tab, I want to add another component to the formula in column C. Currently it brings back the first date from Column X of the 'Activity-Risk' Ta...
Since this is a large data set, I think the best approach is to perform an initial FILTER to pull relevant records to help make the XLOOKUP more manageable.
=LET(
filtered, FILTER(
HSTACK(AppID, date),
(Activity = "Conversion Support") * (ActivityDetail = "Arrange Engagement Call") +
(ActivityDetail = "Arrange Interview"),
"None"
),
lookup, TAKE(filtered, , 1),
return, TAKE(filtered, , -1),
XLOOKUP(all_app_ID, lookup, return, "", , {1, -1})
)
I have uploaded another excel, this time containing all columns I am using in my original spreadsheet. The column where your formula needs to be is in column BG of tab called 'Application Base'. Columns to the right need to be there, so maybe that is what us affecting it?
You're book needed a few defined items and 1 more column to allow the array to spill 2 columns wide. Revised is attached.