EXCEL FORMULAS NINJA: The Top Microsoft Excel Functions to Make your Life and Job Easier! Vlookup, If, SumIf, Xlookup and a lot more (Excel Ninjas Book 1) by Mejia Henry E

Author:Mejia, Henry E. [Mejia, Henry E.]
Language: eng
Format: epub, pdf
Published: 2020-06-03T16:00:00+00:00

“THIS IS A SURE-FIRE METHOD TO MASTER VLOOKUP FUNCTION ONCE AND FOR ALL" - Employee from an Architecture Firm

CLICK HERE TO KNOW MORE ABOUT “EXCEL VLOOKUP NINJA”

HLOOKUP FUNCTION

WHAT IS THIS FUNCTION FOR?

This formula is the brother formula of VLOOKUP. While Vlookup works vertically, HLOOKUP WARKS HORIZONTALLY. So you don't get the column, YOU GET THE ROW THAT YOU WANT.

WHICH IS THE MAIN BENEFIT OF THIS FORMULA?

You can easily find and relate info from a database in order to match the info that you are looking for.

HOW IS THIS FUNCTION STRUCTURED?

The syntax (Structure) of the HLOOKUP function is the next one :

=HLOOKUP(lookup value, lookup array, ROW, range lookup)

WHAT DOES THAT MEAN?

​ LOOKUP VALUE: Is the base Value that you already know. Excel will try to find that value in a database and return another value (in another row) that matches your lookup value

​ LOOKUP ARRAY: Is the range where the data base is located

​ ROW: Is the ROW number (of the database) where your desired result is located. If you want to get the result from the 2nd ROW in the database, you will need to write 2 in this argument.

​ RANGE LOOKUP: This is optional, normally you want to use “0” because that means you want an EXACT MATCH. This way Excel will only find values that match exactly with your LOOKUP VALUE .

Let’s try an exercise.

EXERCISE (Open file Chapter4ex2.xlsx)

​ Now let’s try with a similar exercise than the previous but with a horizontal database

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.