Forum Discussion
Xlookup to return values that is in tabular format
How do I get XLookUp to return the value based on 3-criterias and the corresponding values are in tabular form?
I know I can get if the values 1) Blank or 2) Start/End Mark... are in single column via vlookup. However the dataset is huge (60K lines) and 3MB. My instinct says it will be a long lookup.
In D3:
=INDEX($H$3:$N$60000, XMATCH(1, ($F$3:$F$60000=A3)*($G$3:$G$60000=B3)), XMATCH(C3, $H$2:$N$2))
Fill down.
