Help with Vlookup - maybe?

[higginac]

*SEE BELOW POST FOR ATTACHED EXCEL FILE*
I have a spreadsheet with a column of survey ID's. These survey ID's have the option of having multiple designations in another column. Each of those designations has a letter attached that means something to me. I would like to order them into a row for each instance of a survey ID. The example below will be easier to understand, I think. Example:

excel example.jpg

The data in C_SurveyID and SealCondition comes from an access database that I cannot change. I want to take the data from the SealCondition column and map it to Pipe1, Pipe2, Pipe3 based on the C_SurveyID occurrence (first occurrence = pipe1, second occurrence = pipe2) and have it fall under the correct Survey ID row.

[FDibbins]

This thread is marked as Solved. Did you solve this or should I remove that claim?

[FDibbins]

Also, if this is not Solved, consider upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[higginac]

Book1.xlsx

Attached is the excel file

[loginjmor]

Hi -

You should be able to copy this formula into cell B2.

=IFERROR(INDEX($I$2:$I$31,SMALL(IF($A2=$H$2:$H$31,ROW($H$2:$H$31)-ROW($H$2)+1),COLUMN(A:A))),"")

Click in the editor window and press Ctrl-Shift-Enter at the same time to create the Array Formula. If you do it correctly, Excel will add curly braces {} to the formula. Then copy down and over.

Hope this helps!