There are many types of lookup functions in Microsoft Excel, there is Lookup, Vlookup, Hlookup, Choose, Match and Index. The Vlookup is the simplest and therefore the most popular. The V in Vlookup stands for Vertical lookup. The H in Hlookup stands for horizontal lookup. Most times if your lookup value is presented horizontally you may have decided to select the data and perform a Copy/Paste Special Transpose then go ahead and do your Vlookup Function. If you only knew, you could have simply used the Hlookup function in Microsoft Excel.
When creating a vlookup remember it will only look to the right. If you need it to look to the Left and the right of the Lookup Value use the index function with the match function together.
There are a few things to check before you can go crazy and start typing your Vlookup function. The table must be SORTED by the FIRST column in your Master List or table. Make sure you know the column number before you start typing your function. The structure for the Vlookup is as follows.
=Vlookup(Lookup value,Table,Col Number, False)
You can replace the table data with a Range Name, this will help to understand what the Vlookup is doing.
False or 0 means: Exact match to Lookup value
True or 1 Means: Nearest Lowest match to Lookup value (True is the default)
If you need to find the nearest highest, then the Vlookup is not the right tool for you. Try a different function like Index and Match together.
If you are still struggling AZ Solutions Pty Ltd provides Customized Face to Face training in Sydney – Australia.