How to compare (match) two lists (columns) and when a match is found copy a number of adjecent cells to another location?

[SherlockHomeless]

I need to reorder some data I have.

I have about a thousand cells with data in a column (say column A) and around 800 cells with data in another (say in column B). All the data are strings. So I need to check for every value of every cell in column A if there's a match in column B. If a match is found, 8 columns adjacent to the column B (like for example B1, B2... B[N]) should be copied and 'pasted' somewhere else (for example a few columns to the right of the B column - like in the cells from column K - S or something) BUT not in the same row (just shifted to the right). They should be pasted in a row that matches the cell from column A for which the match was searched in column B.

I made a picture to visualize what I actually need. Maybe it will help.

So far, I tried to use a combination of the INDEX and MATCH functions but I didn't have any luck because all I could achieve was to shift the cells a couple of columns to the right but I couldn't put them in the right row.

Note that I only have basic excel skill and, besides not having enough time, I don't think learning more advanced stuff for the couple of times a year that I may need it would be worth the time required to master it.

Thanks for reading and/or any replies.

 

[jamcall]

Based on the data in your image, try something like this in I11 and drag across and down to cover your range...

=INDEX(C$11:C$16,MATCH($A11,$B$11:$B$16,0))

HTH,
~ Jim

 

[SherlockHomeless]

It works great! Just what I was looking for.

I really appreciate your help. Thank you very much.