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?

Hi:

Try this:

=Vlookup(cell on workbook2 where is the name,range on workbook1 including
both the name and type,2 if this is the column number with the type,FALSE)

This should work if the names are different from each other.

Hope it helps

OSK



"ezil" wrote:

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?