Hi, welcome to the forum

VLOOKUP() will probably do this for you, you would just need to adjust the column to return, for each column needed.

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.