VLOOKUP in Excel - Top 5 Excel Features #1

Revealed: the ultimate Excel function! VLOOKUP and HLOOKUP can turn Excel from a spreadsheet into a database, allowing your sheets to retrieve information relevant to what you are entering from data tables. Download the spreadsheet used in this video: http://software-matters.co.uk/microsoft-excel-help-and-tips.html#excel. Watch the video to see how the functions work and some examples of where they can be very useful. But we only scratch the surface of the power of lookups in this video, so stay tuned for more advanced tutorials to show you some deeper techniques.

See more tips:
http://www.software-matters.co.uk/microsoft-excel-help-and-tips.html

Get more help and advice on Excel, Access or VBA projects:
http://www.software-matters.co.uk/youtube_links.html

Music:
Local Forecast, Mining by Moonlight - Kevin MacLeod
http://incompetech.com/
---------------------------------------------
If you found this video helpful, please consider giving it a Like, leaving a comment or sharing it.

More from the Software-Matters channel:
https://www.youtube.com/channel/UCk-MVP61VQHMdfETVNQEFww

Visit the Software-Matters website:
http://www.software-matters.co.uk/

Software-Matters is based in Gillingham, Dorset, in the south-west of the United Kingdom (UK), near Somerset, Wiltshire and Hampshire and the cities of Bournemouth, Poole, Southampton, Bristol, Bath and Salisbury.

Видео VLOOKUP in Excel - Top 5 Excel Features #1 канала Software-Matters