The VLOOKUP function is a very useful function for handling data, but many of you may have experienced that once you get stuck in the error swamp of #N/A or #REF! In this article, we will discuss how to use the VLOOKUP function to get rid of the #N/A and #REF!

The SUMIF function can be used to change the contents of the total according to conditions, and the SUMIFS function can be used to specify multiple conditions. The reason why and how to use the SUMIF...