vlookups

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookups

Vlookups

resolvedResolved · Low Priority · Version 365

Farouk has attended:
Excel Introduction course

Vlookups

pull multiple datasets from other sheets to one tab.

RE: vlookups

Hi Farouk,

Thank you for the forum question.

Yes you can use a VLOOKUP to merge data from other sheets to one tab, if you have a unique identifier (part number, invoice number, employee ID etc.)

Please watch YouTube vide below to learn hw to use the VLOOKUP function.

https://www.youtube.com/watch?v=TDphx23AtqM


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


 

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips


Server loaded in 0.21 secs.