Excel Lookup Series #6: HLOOKUP Function

[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

[MrAAAAA1982]

Thanks Bro, yo made very easy...

[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!

[azmatsultan]

Bingo! O_o



[yoshiyambao]

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

[ExcelIsFun]

@yoshiyambao , you are welcome!

[Q999Q999Q999]

Thanks for your efforts.

[ExcelIsFun]

@Q999Q999Q999 , you are welcome!

[jeremy0102]

lols. forget about my qns!! to sort horizontally, just go to sort> options> left to right (instead of top to bottom). for anyone who cares to know.. HAHA.

[ExcelIsFun]

Nice!! You figured it out!!!

[jeremy0102]

hello :D

your tutorials are interesting!

i have a qns regarding this though. I understand that we have to sort values in ascending order when we are doing approximate matches. so in HLOOKUP, how do we sort values horizontally? Is it possible?

[xmikedanielsx]

Best piece of info you gave for me was at the end with the FALSE, TRUE values. Thank you for your assistance and your very helpful video.

[ExcelIsFun]

You are welcome!

[blagmusic]

Thanks a million!

[ExcelIsFun]

You are welcome!

[chintu600]

verrrrry gooood

[ExcelIsFun]

I am glad that the videos help!

[rrrrrr12rr]

thanx ........is an understatement but i dont know any other word dude......

[ExcelIsFun]

I am glad that they help!!

[lexiefeng]

lol. how could u make it so interesting! thanks man

[ExcelIsFun]

I am glad that the video helped!

[prasaddd]

Thanks a lot sir . you are great !

[ExcelIsFun]

You are welcome!

[AnimeStudio]

Dude, u totally saved my ass on an assigment that I started 3 hours before its due! <3

[ExcelIsFun]

You are welcome!

I have seen this before:

<3

Now you used it here. What does it mean?

[AnimeStudio]

rotate it 90 degrees to the left, what does it look like?

[ExcelIsFun]

V instead of H.

[dejunius91]

thanks mate

[ExcelIsFun]

You are welcome!

[fogette02]

You mention at the beginning of each video to click on your site, go to college, etc. How do I get to your site to do this?

[ExcelIsFun]

Serach for and watch this title:

Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun

[svtuition]

Great video but greatest your way of guide

[ExcelIsFun]

Dear svtuition,

Thank you!

I can say the same about your YouTube channel and the Google Spreadsheet videos!

--excelisfun

[shiryu008]

In 99% of the formulas i use onle Vlookup. Hlookup it seldoom used.

++++++

[ExcelIsFun]

Dear shiryu008,

Totally true!!

--ExcelIsFun