Hi,
I have a table of around 10k SKUs that I need to first match the prefix on another table (easy bit as I've included a prefix column on both) but then those matches need to partially match the colour suffix in only those corresponding adjacent cells to return the partially matched Colour code from another column in the table. I envisaged a chained xlookup (I have a 365 account), lookup/search but can't figure out how to pair the two to restrict the partial lookup to only the matching prefix rows in the range. The reason for this is there are many duplicate suffixes/colour codes for different prefixes that return incorrect values if the second reverse partial lookup searches the whole range.
Please see attached workbook with example ranges on tabs A and B.
Hoping I can get some urgent help with this.
Thanks in advance.
Bookmarks