Sep 14, 2020
All About VLOOKUP() in Excel
Vlookup is a handy function in Excel. It is a quick and easy answer to lookup requests. It does exactly what we humans normally do when we look up something in a table. [...]
Nov 24, 2020
Comparing and combining two lists using VLOOKUPs
You may remember that in my last blog post, I talked about how to do a VLOOKUP in Microsoft Excel. Today, we are going to use VLOOKUPS to compare and combine two lists [...]
Oct 31, 2020
Doing a VLOOKUP that finds exactly what you want
A VLOOKUP in Microsoft Excel looks up and finds a piece of information in a list, a list like the one below: The V in VLOOKUP stands for vertical because you are [...]
Aug 05, 2020
Keep your Excel formulas in place with dynamic named ranges
So, you have developed an exciting formula somewhere that works perfectly by extracting some value from a specified range and you are quite proud of it. Then one day, [...]
Jul 29, 2020
Returning multiple lookups using Excel's VLOOKUP
Excel's #vlookup function, like every other Excel function, returns only one value from a table. It looks up a table to find a row that has a key value in its first [...]
Jul 03, 2020
Combine MATCH and INDEX in Excel for a powerful tool
If you have used Excel for comparisons, reconciliations, validations or have attended our Microsoft Excel Level 2 course, you will have encountered "VLOOKUP" before. [...]