Lookup to return multiple results in one cell
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
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?
.
Relevant Pages
- RE: Counting numbers in a series
... In cell E1 put this formula and copy down the column ... "Jack" wrote: ... I have a problem that's driving me crazy. ... Say this is my data set ...
(microsoft.public.excel.misc) - How do you Lookup data on different worksheets
... I have a worksheet that contains a cell that I enter in different ... company names such as (Costco, Sams Club, Jack n the Box). ... And from their can you then use a lookup ...
(microsoft.public.excel.programming) - Re: Vlookup problem
... In the adjacent cell, look to see if it returned an error. ... "Dave Peterson" wrote: ... I set the lookup formula in enquiry.xls to lookup the tel nos. ... The enquiry.xls is with the vlookup formula to lookup the data in data.xls. ...
(microsoft.public.excel.misc) - RE: combining LOOKUP and IF functions
... You need to use Match and get a cumulative sum of you percentages. ... cell I2 =A2+H2 ... It may be possible to use Lookup ... excel spreadsheet and then plot the result of the model. ...
(microsoft.public.excel.worksheet.functions) - Re: Macro partial autofill
... 'when entering data in a cell in Col A ... If i close the workbook, and open it again, i need the time to remain 10:55. ... and you make an entry into C on that row, then the lookup is done and what ... name of your database sheet. ...
(microsoft.public.excel.misc) |
|
