Excel: Combining Vlookup and Match Functions

In this short video you will learn how to combine the VLOOKUP and MATCH functions in Excel
Want more free training? Check out theexceltrainer.co.uk/learnexcel
Connect with me via:
Twitter: / thomasmike
Facebook: / thomasmike
Facebook: / theexceltrainer
Google+: plus.google.com/+MikeThomas67
LinkedIn: / thomasmik
Blog: mthomas.co.uk

[@ramanjha5356]

Awesome explanation. I think I figured some of this out for the 1'st time in my life.

[@Allona33]

Excellent!! I have been struggling but you explained it so clearly, thank you.

[@ACDeeBee]

This is a great video. Seeing you hard code in a number in the vlookup and then replacing it with the match function was especially helpful in clearing up the confusion I've had with learning to nest functions. Thanks!

[@ThomasMike67]

You are welcome!

[@nawaf356]

Very good explanation! A lot of Thanks from Saudi Arabia.

[@dedehalmeida]

Very didactical. Thanks for this great video. You made something complicated look easy.

[@engw7090]

great tutorial! thank you

[@martymcb]

Thanks so much mike, my forecast lookup is working easy peasy!

[@BillyHutabarat]

thankz you.. your video help my report and i understand what MATCH mean, Thankz!

[@BSlingzz]

Thank you

[@nasarkapoor9815]

Thank you very neat explanation

[@soaadfaisal548]

Amazing : thank you

[@GeorgeAJululian]

Many thanks Sir it was very helpful

[@martariya6438]

Very useful 👍🏻

[@thenameishumantoo]

Thanks man :)

[@konstantinaman3414]

Very useful video

[@MehediHassan-mn9rt]

Helpful

[@saifankhan5873]

Time Stamp 5:35

[@patriot_1776]

Very concise, thank you. BTW it's pronounced "aych" not "haych" :)