Use datafilterautofilter on the number

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PSU35" wrote in message
...
I hope I can explain this clearly.

I need advise on how to write a formula that will:
1) look thru a string of cells in a column for a match to a number
specified in another cell
2)then return the person name located in the cell next to the match

Sounds simple except ther will be multiple matches to the number and each
match can have a different name. I need to show all the names that match,
seperated by a comma, in this one cell.