Hi Superusers

Wishing you a good week.
I need your help please.

Attached is the file that has 3 sheets:

Before - has 2 columns: ItemID & ItemLocation which needs to be filled with data from Sheet 1 for the matching ItemID from both sheets : Sheet 1, Before
Sheet 1 is where you get the ItemLocation from
After - is what the Final result should be

Thanks a lot for your kind helpItemLocation.PNGItemLocation.xlsx