index matching betwwen work

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Index matching betwwen work books

Index matching betwwen work books

resolvedResolved · Low Priority · Version 2016

EMMY has attended:
Excel Introduction course
Excel Intermediate course

Index matching betwwen work books

Modifying a work book from a colleague and not interfering with the contents

RE: Index matching betwwen work books

Hi Emmy,

Thank you for the forum question.

I am no sure I fully understand your question.

Index and Match functions can lookup data from another workbook. It will not interfere with the content in the source workbook.

If you want to learn how to use lookup function to get data from some ones workbook, I found a video on Youtube which can be a help.

https://www.youtube.com/watch?v=2erErC7LvPY


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 29 Aug 2019: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.12 secs.