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

index matching betwwen work

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

Index matching betwwen work books

ResolvedVersion 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.

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.