Excel Lookup Series #6: HLOOKUP Function

See how to use the HLOOKUP function! We all know how to use VLOOKUP, but how do we use HLOOKUP? See how to use HLOOKUP in this video.

In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.

This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.

Category:

Science & Technology

Tags:

• Excel
• HLOOKUP
• function
• formula
• VLOOKUP
• LOOKUP
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[liliaqweqwe]

I see! Now i get it :)

[ExcelIsFun]

@liliaqweqwe , cool!

[mcsullivan94]

im still having trouble with mine because mines a big word database for my A level exam so when i need to enter the lookup value and other stuff there on a different page, please help. Thanks. Btw ur videos are awesome :D

[ExcelIsFun]

@mcsullivan94 , try video:

Highline Excel Class 07: VLOOKUP function formula 7 Examples

[GoPAKIZ]

i love the energy and positivity in the video and it is extremely help full thanks alot .... (BUT EXCELL IS STILL NOT FUN !! well atleast at my school)

[ExcelIsFun]

@GoPAKIZ , I am glad that you like the videos!

[MrAAAAA1982]

Thanks Bro, yo made very easy...

[azmatsultan]

Bingo! O_o

[ExcelIsFun]

@yoshiyambao , you are welcome!

[yoshiyambao]

I've been watching all the videos since the excel basics series and have been learning alot. Thanks again Excelerator!