Hello everyone,
I was hoping to get more of your expert help with excel. I've been trying for two days but can't seem to figure out what I am doing wrong or if I am even going in the right direction, I'm hopeful someone here can help me please.
I am trying to get excel to look at the values in each row of sheet1 and see if they are an exact match to any row in sheet two. If so I want excel to take the Value in the value column of sheet2 and place it in the Column1 of sheet1. For example if row 1 sheet1 has N Copy Empty No and row 5 in sheet2 has the same values in the same columns then I want it to return the value in the Value column of sheet2 to column1 of sheet1
I've tried everything I can think of but can't get it to work. I have attached a sample workbook so you get a better idea of what I'm trying to do
Any help is greatly appreciated.
Have a great day
Bookmarks