updation from another workbook

E

ezil

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?
 
O

OSK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

STOP close button on another workbook 6
Continue macro from current workbook 0
To copy Data from a row in one wrokbook and insert in a sheet of another workbook 0
Copy data from workbook 2 to workbook 3 mystery! 2
VBA code for pasting links -- modifying RDB code for summary workbook 11
Using VB to pull formats and data from another workbook 0
Is Excel Threadsafe 13
Copy all worksheets to another workbook, excl. duplicate sheets already in other workbook 2

Top