Hi All,
Is there a way to vlookup multiple records in 1 cell? I actually did a vlookup search but found that those multiple records in 1 cell does not appear in the result.
Below is the sample; eg: search the number of 123 or 45 or 789 and return the value as Apple and Jane.
number Category Name
123 (a)
456 (b) Apple Jane
789 (C)
Appreciate for some advice.
Thanks in advance.
Bookmarks