i-teach-u Excel Vlookup HLookup Average Sum Min Max

[pureassyrian1]

I have a test in a couple of hours on excel functions and this helped me. Thanks!

[JackBarnett21]

@pureassyrian1 excellent - glad to be useful.

JackBarnett21

[shekpes]

thanx lot...first time understood vlookup hlookup...great work

[JackBarnett21]

@shekpes Hey Shekpes thank you very much.

You are too kind.

Jack

[shekpes]

thanx a lot..... first time i understood vlookup ,hlookup.....great work carry on..best wishes

[JackBarnett21]

@ivision18 excellent - nice comment cheers

[greeengiaant]

Nice one m8, forgot the the F4 but now OK...will check all you videos for more info...Cheers.

[CantFndaName]

Thanks a lot!

So well organized and so simple.......

[JackBarnett21]

My pleasure

[rafiq25pk]

I am using Excel since last 5 years but for the 1st time I have learned Vlookup function. Thanks

[1248163264128256512]

yer my dads been using spreadsheets for many many many years and when i told him we were doing about vlookup and hlookup's he was like "what the hell "hlookups"?"

and i was like.... yeeeer..?? horizontal lookup and vertical lookup

"OOOOOOH, i thought it was only vlookup standing for value lookup" lol

and he knows alot about spreasheets

learn something new everyday lol

[JackBarnett21]

You're too kind. Thanks a lot. Look at other lessons. Best wishes JackB

[js7389]

there is no space in the 2nd goal! either idk y that appeared

[js7389]

can you tell me what is wrong with this statement?

=HLOOKUP(Budget!L24+Goal!F7,Go­al!C$14:Goal!G$15,15,TRUE)

[JackBarnett21]

I am not sure - it could be that you did not sort your work in ascending order first.

or perhaps you did not make your work absolute by pressing F4 when you wanted something to be absolute..

[alzeerabolalah]

thank u