westend9876
Member
I have a list of values in column FM on Sheet1. I need to match these values from column FM Sheet1 with those in column A Sheet2 and populate column F Sheet1 with the values from column D Sheet2.
SHEET1
....F...............FM
Order.........Values
..................91001
..................91001
..................91001
..................90701
..................90701
..................90701
..................90077
..................90077
..................90077
..................90077
..................90049
SHEET2
A...................D
Values.........Order
90077............1
90701............2
90049............3
SHEET1
....F...............FM
Order.........Values
..................91001
..................91001
..................91001
..................90701
..................90701
..................90701
..................90077
..................90077
..................90077
..................90077
..................90049
SHEET2
A...................D
Values.........Order
90077............1
90701............2
90049............3