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

[salvi447]

crap! what version of excel is this? 1980?

[TheIrreverend]

Excel IS Hell, my friend! I like how you threw that in there. I really appreciate your in-depth explanation of How, as well as WHY, everything worked the way it did! I've been using a lot of Vlookups, and needed a reversed perspective on the method to see if I could utilize it in some way. I'm working on figuring out how to combine V and H lookup functions, inside a conditional IF scenario to yield certain text results in the cells that qualify. Perhaps you could help me with this? Please

[rhythmspiral]

You explain this very well. Thank you!

[DosEquisIAM]

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?

[theneelrocks]

Thanks.

It is very useful for me.

Thanks again.

[ecceservices]

giving up a free video, then at the same time alienating g people with your greed (OH GO TO MY SITE), really leaves people not wanting to bother with your vidoe on youtube, neither in stupid site.

[04UlquiorraSchiffer]

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

[LindaDooWop]

That was an excellent lesson!  Thank you so much!

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

[ExcelisHell]

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

[niaalll]

@ExcelisHell Thanks :)

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

[PRASADPETKAR1]

i learn t all things for this video thank u very much

[tahirgshahid]

thanks very much



[msraymond]

this sucks big time!

[khanvis2009]

Out of all the videos on YouTube teaching excel , yours is the best .

[NISHANTway]

its profit to see ur video :D

[tomtyr32]

thanks!

[firecrackers1]

Thank you, you really helped me because

I have an exam tommorow and that function is included.

5 stars

[sanaulhaq]

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

[TSM9356]

cheers mate

love life eat less meat

[MariaKlaraXVI]

You are a born teacher. Thank you! The more explanations I read today, the more mixed up I got. I think there's hope for me now.

[B1aze182]

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

[Anazull]

Thankyou very very much, I spend the whole evening trying to do that, and I did, but I didn't how and why, so thankyou for your explanation it was very helpful.

[ChanFlex]

I forgotten how to do H/V lookups these videos are a great way to review.

[insomanic123]

great job