Excel: Combining HLOOKUP and VLOOKUP

You may need to familiarise yourself with VLOOKUP and HLOOKUP first. Here are tutorials to help with that:

I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

[ngwafabrice]

Thanks alot. You don't how much time this has saved me❤❤❤

[xARCxLif]

I literally just spent about 2 hours trying to do this, and you my friend have just saved my sanity. Thank you.

[marwantarek]

I watched like 4 videos to be able to combine Vlookup & Hlookup but this one was the best. Thanks !

[abdelkhalekbakkari]

very useful tutorial thank you so much, i would like to know if i can get the city IDs from another sheet, actually i have a country list wich every country belong to a specific zone, there are 7 zones.

[McGeeConsultingTV]

Brilliant!  I spent about an hour reading 3 or 4 blog post!  Then I found this and you nailed it for me in about 4 mins..thank you!

[dianablock]

You are amazing - I just tried this out and this is going to save me a lot of time. THANK YOU!!!

[Nikhilmandekar]

Awesome video, very useful. It takes time to learn this formula but it's awesome. This formula Saved my too much time.

[tcpromac]

Thank You, you just helped me to solve a search box.

[bakuya]

thank you for uploading this i needed something like this because
i have a programming class.

[richardtyson]

Thank you so very much! Awesome tutorial.

[teekaymlambo]

Good stuff, easy to understand, thank you

[bassamsalah]

i did every step but not working with me it gives me #reff

[sharlenetoolsie]

Wow this is a life saver. Thanks a million

[jacksonsmummy]

Great video although I can't seem to get my spreadsheet to do the same. I followed your instructions and tried numerous times but I keep getting N/A! I don't know where I am going wrong.

[jacksonsmummy]

If I send you the spreadsheet (it is hyperthetical as I am studying AAT and have an exam in 2 weeks) could you please show me where I am going wrong?! I have been trying for hours even trying to use MATCH and INDEX as mentioned in other videos but no luck! I am clearly missing something fundamental!! Thank you!

[abdallahm.atyfmeshref]

It is better to use this formula instead of creating a special row for the equation
=vlookup(B2, A10:A13, match(B1, A8:E8, 0), 0)

[Xarin]

Thanks for this mate you are a life saver!

[samtaclaus]

Thank you so much for this . .. .it really helped a lot . . .