Hello there,
I have two separate workbooks.

The data in book 1 is identical to the data in book 2, however book 2 has a column which is not in book 1.

As I have some common data, ie an order number, is it possible to use a formula to pull the desired column from book 2 over to book 1?

Thank you!