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

vlookups

ResolvedVersion 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

Fri 19 Jul 2024: Automatically marked as resolved.

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

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.