Using V-Look Up to transfer data from one workbook to another

[umarraza]

Hi,

I am not very good with excel hence the post. I am trying to transfer data from one workbook to another (without copying and pasting it) using some sort of V-look up formula or any other that I may not be aware of. I have given an example of the data set below:

Workbook1:
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Reference Number[/TD]
[TD="align: center"]Fixed[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]39217[/TD]
[TD="align: center"]Yes[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]17390[/TD]
[TD="align: center"]No[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]19283[/TD]
[TD="align: center"]No[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]18304[/TD]
[TD="align: center"]Yes[/TD]
[/TR]
</tbody>[/TABLE]

Workbook2:
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Reference Number[/TD]
[TD="align: center"]Fixed[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]39217[/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]17390[/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]19283[/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]18304[/TD]
[TD="align: center"]?[/TD]
[/TR]
</tbody>[/TABLE]

In Workbook2 from cell B2 to B5 I would like to use a formula to pick up the yes or no from Workbook1. I dont want to copy and paste the results over as this is just an example but the work I will be doing contains thousands of data entries being updated at various times.

Alternatively, if there is a better way of doing this, please do let me know.

This is my first post, so apologies in advance if I have not followed the correct protocol or etiquette of posting a thread.

Thank you for your help.

UR

 

[Aeiryy]

Try using this:

='[file.xlsx]Sheet1'!$B:$B.

Highlight Column B in workbook 2 and paste that formula in. Then just drag the formula down as many cells as you need.

 

[umarraza]

Thank you so much, it worked