AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() 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. The H in HLOOKUP stands for horizontal lookup. The V in VLOOKUP stands for Vertical lookup. The VLOOKUP is the simplest and therefore the most popular. ![]() There are many types of lookup functions in Microsoft Excel, there is LOOKUP, VLOOKUP, HLOOKUP, CHOOSE, MATCH and INDEX. If you have an Invoice No, Order No, Product Id use the VLOOKUP function to bring back the description. You could use a VLOOKUP for the purpose of making a smaller list and then using that list to create a PivotTable. Use a VLOOKUP to make a smaller refined set of data and the data is still linked to the original so as updates occur you still have the latest information. Imagine you have a massive set of data it goes on for ever, but you are only interested in a handful of columns from this data set. ![]() It looks for a matching piece of information finds it in a table and brings back information it found from a specific column. What is a VLOOKUP? When should I use it?Ī VLOOKUP function in Microsoft Excel is a glorified copy and paste tool. Great, you have been told you need to do a VLOOKUP. ![]()
0 Comments
Read More
Leave a Reply. |