HLOOKUP() in Excel - how to use it and edit it. Walkthrough explanation.

Excel Courses: www.teachexcel...
Excel Forum: www.teachexcel...
More help: www.teachexcel...
How to use the HLOOKUP() function in Excel. Explains how it works and teaches you how to use it. Also compares it to the VLOOKUP() function and explanes the difference.
To follow along with this worksheet and to get more excel tutorials, keyboard shortcuts, and macros, go to:
www.TeachMsOffi...

[@sompod8660]

man I seeing this after 12 years later

[@TeachExcel]

@niaalll put dollar signs in front of what you don't want to change A1 -> $A$1 - it's called absolute cell references

[@Stormymystic]

I want to think you for this video, I had to do an explanation of what this function did in a college class, and if not for this.. I am not sure I would have understood it.

[@timprice1106]

Can't wait to show this to the family when I get home this evening

[@emmakansha]

thanks

[@akbarali-xi5eh]

hello

[@marimuthugovindaperumal2759]

Thanks for your detailed and very good explanation :-)

[@niaalll]

How can you drag it to other boxes without changing the numbers
if i have this code "=Hlookup(J2;B1:H2;2;True)" in box J1, then try to copy the code to K1 it then becomes (K2;C1:J2;2:True) so its using a different array. any clues how to sort it out?

[@jamesdryden164]

Thanks I

[@firecrackers1]

Thank you, you really helped me because
I have an exam tommorow and that function is included.
5 stars

[@prakashkanthale4849]

Thanks.....it's very good tutorial for easy way to learn Hlookup

[@shahfibre]

This is the right way to do hlookup problems. People apply hlookup formula to the orientation of data that is applicable to vlookup. Correct data orientation is this one

[@tbomber]

@ExcelisHell now what if I want the ROW # to change when I drag it to other boxes... so using the example, if I have several years' worth of data that extend past Jan/Feb/March? If you drag it, the row # stays the same. But if I have a lot of data it's way too difficult to change it manually for each box.

[@inangmundo3772]

You are right about that Excelishell.com...hahaha

[@harinchandramouli]

Well explained , Best way to learn from you!!! Kudos :-) i suggest if you keep the text running at the bottom of the video..coz few people cant understand the accent!! Just a suggestion , dont mind...

[@rhythmspiral]

You explain this very well. Thank you!

[@Ty33Budd]

4:57 Here lies a problem that I need a solution to, I want to use my excel sheet in a reverse method, but I want to search in Row 4, and for the formula to relay to me what is in Row 1.
Here you say it will only search in the First Row, so is there another function or work around for this?

[@bossvasan]

use index and match

[@Tidewater_paddler]

Lets say I have 3 sheets: Sheet 1 (numbers), Sheet 2 (characters), Sheet 3 (total).
I am trying to take data from sheet1 and pass it to sheet 3 on cell A1 through E1
Next I want to pass the data from sheet 2, on to sheet 3, rows A2 through E2
I am trying to set the function in the cells in sheet 3, so that when the user types their data, it is automatically posted. Any suggestions?

[@LindaDooWop]

That was an excellent lesson! Thank you so much!

[@lulzimazn]

dude i was doing some excel homework and was screaming at my computer because it kept pulling the wrong numbers, but you explained the last column rnage lookup and that was my problem i need it do be false. You saved my monitors bro. good shit.

[@jedmcalindon5536]

yo can i teach this to my dawg? he be trippin

[@sloppyjoe2073]

How the hell are you?

[@saltypretzelpro]

i cant DO IT ANYMORE AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH

[@sloppyjoe2073]

Shout out to my boy Donnie Longmore

[@donnielongmore857]

subbed

[@sonythomas100]

well explained, thanks for the video ♥♥♥

[@oladipupoayoola1403]

Very helpful. Easy to understand. Thanks much!

[@Rahulkuril93]

You are very nice explain.i Goted

[@thqidwai.]

thank bro, I had kinda learned it myself already but this video sure did help understand the function a beter way

[@sangupatil1]

Thanx for the explanation better understand..!!!!

[@njerzynek]

if you need 2 rows in Jan and 3 in Feb why nightlight 4 in both???

[@charminghongkongkr]

Thanks a lot for the video! Really useful!

[@alpstinger5083]

This cleared everything!

[@Rahulkuril93]

Can you explain macro

[@bajuk70]

its very useful video for learning for HLOOKUP ...thanks

[@s99bf0c8]

sound on this video sounds like abbey road being played backwards

[@sanaulhaq]

I work in bank in Karachi, Pak and u really help me a lot, god bless you man. Thanks

[@enterprisesenterprises8320]

bank name sana
hope you help me..... me ali here

[@kinjalhazare4797]

VERY HELPFUL THANKS...

[@TheHiteshsolanki]

Hi kinjal..

[@enterprisesenterprises8320]

kinjal you from

[@MrGuitarchum]

Fuckn creep

[@SuperKirkb]

what the f is wrong with ur sound

[@ThinusJ]

Very nicely explained. Thanks !

[@04UlquiorraSchiffer]

Thank you man... It helped me a lot...!!!!!

[@Tridezuki]

Thank you soooo much TechExcel !!!!

[@skshajadaali3457]

Sir Hindi me bolio

[@bharatchander7619]

very helpful,,thanks

[@niketanoberoi1863]

thanks, very helpful.

[@msraymond]

this sucks big time!

[@ribasuki6899]

Pagi semua

[@TheOkiedave]

never had instructions before from a dalek lol

[@kimstewart6129]

Good job. Couldn't do it without you.

[@rohanpurohit4217]

this helped alott thanks

[@Rahulkuril93]

Send me macro 🔗

[@sunilkhari7184]

that good explanation

[@tahirgshahid]

thanks very much

[@ahfwz6897]

Thank U mat

[@jitendraprakash6063]

Helpful

[@swathisalandri410]

awsomeeee

[@munchinss6042]

2019 peeps wassup!!

[@tomtyr32]

thanks!

[@siddharththan5255]

Thank you

[@shakyaboy9643]

help full

[@sarojkandel3718]

I subscribed

[@mastermind3062]

Nice

[@abhijitsoni5413]

thnk you

[@shakyaboy9643]

thanks

[@B1aze182]

Very nice, thanks!!! Saved my ass for my uni assignment XD

[@shaileshbahuguna2606]

mine too.

[@niaalll]

@ExcelisHell Thanks :)

[@amreenrahman7819]

Really Helpful

[@enterprisesenterprises8320]

yup you'r ryt armeen