Matchv values on two different excel workbooks

  • Thread starter Thread starter Jack
  • Start date Start date
J

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
 
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.
 
Thank you, dave

Dave Peterson said:
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.
Click to expand...
 
Back
Top