referencing cells separate work

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Referencing cells in separate work books

Referencing cells in separate work books

resolvedResolved · Low Priority · Version 365

Daniel has attended:
Excel Intermediate course

Referencing cells in separate work books

What is the best way to reference cells in separate workbooks?

RE: Referencing cells in separate work books

Hi Dan

Thank you for posting your question on our forum.

It all depends on the structure of your data on different workbooks and how you want to reference the data. If you have source data in workbook #1 and you know it won't be filtered/sorted at all then the other workbook (#2) can reference the cells just by creating links.

However, if workbook #1 is going to be filtered/sorted, then links to cells will not reference the correct data. In this case you will need a Lookup formula in workbook #2 to look up a unique id number in workbook #1. Examples include VLOOKUP, MATCH and XLOOKUP.

Here is a Youtube video of how to get started with VLOOKUPS:

https://www.youtube.com/watch?v=hwL6KKJP-_I

As your question is quite general, it may help to be more specific in exactly what you mean by referencing cells.

Please let us know how you get on

I hope this helps

Kind Regards
Martin

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.


 

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips


Server loaded in 0.09 secs.