My task is to update label "type" of workbook2 from label "type' of workbook1
for label "name" as given below. (the order of "name" in both workbooks is
not same)

workbook 2

Name type

A
B
C

WORKBOOK1 (SOURCE)

NAME TYPE

B 1
C 2
A 3
d 8

What will be the formula or program to do this?