by Colin Foster | Jul 9, 2021 | Microsoft Excel
As you become more experienced with Excel, you get comfortable with the idea of “nesting” one formula within another one. A classic use of this is with nested IF() statements where the first IF() checks a TRUE/FALSE option & then the Value_If_True and...
by Colin Foster | Aug 13, 2018 | Microsoft Excel, Tips and Tricks
The #N/A Error If we use the VLOOKUP Function to match between two sets of data – then occasionally, Excel will return an #N/A error where it can’t find the value in one list in the other one In this example, we have two lists of employee data where in the...
