The VLOOKUP function in Excel is used to pull data from a row knowing at least one piece of information from a column about that row, however it has its limits. For instance, you cannot pull data using multiple criteria. Additionally, if you have a list of items within your Excel dataset that may contain…