Forum Discussion
vlookup two references from a single cell....
Hi, I have tried searching for this query on forums, but not finding what I require. Basically, I would like to be able to vlookup two references within a single cell separated by a comma/sla...
One day, if you are lucky, you may get to use a 365 license in which case
= MAP(codes, LAMBDA(v,
TEXTJOIN(",",,
XLOOKUP(TEXTSPLIT(v,","), products, description)
)
))will return the entire column of product descriptions.