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:

	A	B
1	Reference Number	Fixed
2	39217	Yes
3	17390	No
4	19283	No
5	18304	Yes

<tbody>
</tbody>

Workbook2:

	A	B
1	Reference Number	Fixed
2	39217	?
3	17390	?
4	19283	?
5	18304	?

<tbody>
</tbody>

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