Formula question

A

Amanda

I have a worksheet with client names in multiple columns. I want to be able
to have a cell where someone can enter a last name into it, and the formula
will return all of the company names (which is in my column A of every
record) for each record the last name is found. Does anyone have any ideas
on a formula that could do this? Thank you so much for any time spent on
helping me.
 
C

comotoman

I have a similiar setup right now, but in order for it to work, you need
to device a form of grouping. The way I have to set it up was Clients
Names, Last, First. Then all the companys they are associated with.
That would enable you to select the name in a drop down list, in
another cell of your choice a drop down list would come up with all the
companys names for that person. Another more complicated way I cant
explain, it envolves offset, match, and lookup formulas. But it would
enable you to type all or part of the name and the companys will show
in a set amount of cells. Again, grouping is key. Let me know what
intrest you the most and I may be able to get you going.
 
A

Amanda

Thank you very much for your prompt reply to my question. The second option
interests me more. I don't understand what you mean by grouping.

Thank you.
 
Top