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.
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. Read More