HLOOKUP – The less-know sibling of VLOOKUP - EBOOK VBA EXCEL

EBOOK VBA EXCEL

EVBA.info ( Ebook VBA Excel ) Welcome EVBA.info - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Search This

Tuesday, December 3, 2019

HLOOKUP – The less-know sibling of VLOOKUP

HLOOKUP – The less-know sibling of VLOOKUP

Many people talk about VLOOKUP and agree that it is one of the most useful functions in their work life with Excel.  However, if you ask them about HLOOKUP, maybe 30% of them have no idea of its existence.  The Google search result may reflect a little bit…Excel Tips - HLOOKUP

The result is not surprising at all given the nature how we are taught to organize data in a table.  The rule of thumb:  each row holds one record.  Therefore we are likely to have a vertical table like the screenshot below which is ideal for VLOOKUP.
Excel Tips - HLOOKUP 1
To answer a question like: What’s the gross value of box office for “Despicable Me 2?” is simple with VLOOKUP.
Nevertheless in real world, we are facing with too many varieties.  Most of the time we work with data not so organized, nor not in the way we expected.  There is a high chance that you end up with a horizontal table instead…
Excel Tips - HLOOKUP 2
Technically, the table is not too bad.  It’s just not good for VLOOKUP.
COPY and PASTE Transpose maybe something in your mind if you don’t know about HLOOKUP.  Why? Because you want to transpose the table and make it good for VLOOKUP(tips: just in case you do not know, you may transpose a table, i.e. convert a vertical table to horizontal; or vice versus, by Copy and Paste Special –> Transpose)
However after you read this post, HLOOKUP should be on the top of your mind if you need to figure out a question like: What’s the gross value of box office for “Despicable Me 2”?

The following table summarizes the differences between VLOOKUP and HLOOKUP.Excel Tips - HLOOKUP 3
If you can manage VLOOKUP, there should not be any problem for you to manage HLOOKUP, as long as you know its existence.
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment