- Home
- VLOOKUP
INDEX MATCH An Alternative To VLookUp
Having worked with and trained a range of people from different departments and businesses, I have seen that the VLookUp is the function that I am most asked for help with or training on. Here I would like to show you an alternative to the VLookUp which is INDEX MATCH. INDEX MATCH solves some of […]
Continue readingVLookUp To Retrieve data relating to the second or third match
If you have ever used VLookUps before you may have noticed that the formula only retrieves data relating to the first match it finds. Did you ever need a VLookUp to retrieve data relating to the second or third match? In an earlier post called VLookUp with multiple values and I showed you how to retrieve […]
Continue readingVLOOKUP
The VLOOKUP is one of Excel’s most useful functions. In its most common form, it is a database function which works with lists of things in databases, or Excel worksheets. Your list of things can be pretty much anything, names and phone numbers, part numbers and details, details of your album collections, etc. A VLOOKUP […]
Continue reading