This post details some of the common limitations you will encounter while using the Vlookup function. Following are some of the limitations of the Great Vlookup Returns data related to only the first occurrence of the lookup value Work with only one criterion Returns an error when no match of the lookup value is foundContinue reading “LIMITATIONS OF VLOOKUP”
Category Archives: Excel
VLOOKUP DECODED
Vlookup is one of the most commonly used functions of excel. There are numerous data lookup tasks that we want to do and vlookup does them just as a charm. Before getting into the syntax of the function, let us first understand what it really does. We use the vlookup function in our head allContinue reading “VLOOKUP DECODED”