Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup to return multiple results in one cell
Name # of cats
Jack X123 Jack X224 Lisa X123 Ben Z324 Derek X123 Derek Z324 Above is my example data set. Ideally what I would like to do is be able to have concatonated results on one line based off a lookup. E.g. I look for Jack and the formula returns: "X123, X224" in one cell. Is there anything out there that can do that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to return multiple results in a cell | Excel Discussion (Misc queries) | |||
lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
lookup one value in list and return multiple results | Excel Worksheet Functions | |||
V lookup with 2 criteria to return results for multiple columns | Excel Worksheet Functions | |||
Return Multiple Results with Lookup | Excel Worksheet Functions |