Populate from separate sheet

[zeroarctic]

I have 2 spreadsheets. I need to populate a blank column on one sheet from a populated column on the second sheet. The common number is column 1 , PAN. The source sheet has column B , street address. The end sheet has column D blank. That needs to be populated from column B on the first sheet using column a, PAN, as the common entry.

[Sam Capricci]

I would look into either vlookup or index/match for that. It is difficult to tell which you might need and how discrete your data is (like are there duplicates in one column but having different values to return in the other). You might consider posting a sample workbook with what you have (desensitized of course) AND your expected results and an actual formula could be devised for you.

[zeroarctic]

Thanks for the answer. What I need to do is to extract column B , full_address, from sheet 1 and postulate column D, Street_Address on sheet 2. The common, or match, on both sheets is column A, PAN.

[Sam Capricci]

this would be one way in cell D2 of Sheet2 dragged down...
=VLOOKUP(A8,'Sheet1'!$A:$B,2,FALSE)
for it to work you would need both sheets open.
So, an option is to open both workbooks, use the vlookup to bring over the values, then use copy >> paste special >> values then close the sheet 1 workbook.

this article will show you ways to reference closed files...
https://www.extendoffice.com/documen...ened-file.html