How to do a VLOOKUP with multiple criteria in Excel
There are times when you want to return a match for a VLOOKUP based on multiple criteria. For example, we may have customers…
-
-
How Change Case in Excel
In this blog we will cover how to change the case of your text in Excel with or without a formula. If…
-
Excel – Using VLOOKUP to compare two lists
If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two…
-
How to create a list of Working Days – Excel WORKDAY function
This post has been updated and added to by Sharyn, November 2020. Need a list of weekdays or workdays only? Let’s look…
