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 colum...
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.