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.
--
Amanda