Is there a formula tweak for XLOOKUP to look in all rows of data within a cell? In attached example, I'd want to be able to find 47348 and/or 47349, etc. instead of it just looking at the first value in the cell (47345).
This is working absolutely great, but I'm curious now if we can add an additional wrinkle. Now I believe the wildcard search stops at the first "find", can the search continue and return additional "finds"?