Find a second occurance or third or fourth

[seth2613]

I am trying to find an in-cell formula to find a cell with a specific value and return the value in column A of the same row. Typically this is handled by Lookup or VLookup or HLookup. However, these only find the first occurrence of the value, I even know how to find the last occurrence, but what about in between? In my spreadsheet I have reoccurring values that I need the value in column A of the same row, but I need more than just the first or last but every instance in between. Anybody know how to do this?

[Ron Coderre]

Can you post some sample data and the results you want to see, based on the sample data? If you can attach a workbook, that would be exceptionally helpful.

[seth2613]

I hope this helps.

[Ron Coderre]

Here you go...
Using your posted workbook, this regular formula begins the list of part numbers:

Please Login or Register  to view this content.

Copy that formula down through C11

Is that something you can work with?

[seth2613]

Thank you sir, I do believe this will work.