I need help transferring across data from one sheet to another

[GWells]

Hi guys,

So I have a spreadsheet with a list of item codes and a subsequent excel sheet with corresponding item codes. I would like to match up the item codes and enter everything found between column E to L.

Please find the spreadsheet attached.

Thanks in advance!

[Richard Buttrey]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[bullsb]

You can use VLOOKUP. However, there are many duplicate / repeated Items.

[GWells]

Oh yes, I have over-simplified the data I have. The Item numbers are also sub-categorized by a code, either "EACH", "OUTER", "PALLET" or "TRANSIT". Please find a slightly less-simplified of the data attached. Hopefully it is possible with this!