Hello,
I am looking to match text contained within one cell to an array that contains a bunch of text to return another text value based on which column it was in.
I have a list of tenants that populates based on their outstanding rent from high to low.
Based on this, I want to match the tenant to which property they are located at. I have a data set located on another tab that contains this data.
I have tried using index match and xlookup to no avail.
Any help would be greatly appreciated. Thank you!