Thats really impressive. I like how the code can return an array. So I have a big confession, I don't know VBA. I do know DAX and a bit of M, which are new languages used in Excel. but I never learned VBA.
Now following, I know I will learn some neat tricks from you :-)
RE: XLookup almost has everything I need