Matchv values on two different excel workbooks

[Jack]

Hi Team;

I have difficulty in matching data in two worksheet.

I need to match tow values and place correspond value to first workbook.

Generally I do it with vlookup for same worksheet.

I am not sure how to do with two different workbook.

Please help!

Thank you,

Jack

 

[Dave Peterson]

If you let excel do the heavy lifting, you'll see it works the same way.

Instead of typing the formula, use the mouse to select the ranges.

Open both workbooks
type: =vlookup(a1,
and then use Window to select your other workbook.
select the worksheet that has the table
select the range that contains the table
and finish up the formula--like: ,3,false)

Excel will adjust the formula when you close the "sending" workbook.

 

[Jack]

Thank you, dave

If you let excel do the heavy lifting, you'll see it works the same way.

Instead of typing the formula, use the mouse to select the ranges.

Open both workbooks
type: =vlookup(a1,
and then use Window to select your other workbook.
select the worksheet that has the table
select the range that contains the table
and finish up the formula--like: ,3,false)

Excel will adjust the formula when you close the "sending" workbook.