I have as spread sheet with 5 vertical columns on the right side, I need to search these columns with 500 rows for one text value, when found go straight to the left of the found value to a set column, get the value (text), then continue scanning down the sheet until all matches have been found then produce in the cell a text string of all the matches, example would be: C-100, P-101, C-203, ect... may be as many as twenty to thirty matches. Note: Searches with be text match not numbers. Ron Ross ron.ross@edginternational.net This may be in the wrong spot to ask this question but, kinda new to this.
