The VLOOKUP function is mighty USEFUL, but it ALSO has a few limitations:

It can not be used when the lookup value is on the right. For VLOOKUP to work, the lookup value should always be in the left-most column. Now this limitation can be overcome by using it with other formulas, it tends to make formulas complex.

VLOOKUP would give a wrong result if you add/delete a new column in your data (as the column number value now refers to the wrong column). You can make the column number dynamic, but if you planning to combine TWO or more functions, why not use INDEX/MATCH in the first PLACE.

When used on large data SETS, it can make your workbook slow.

The VLOOKUP function is mighty useful, but it also has a few limitations:

It can not be used when the lookup value is on the right. For VLOOKUP to work, the lookup value should always be in the left-most column. Now this limitation can be overcome by using it with other formulas, it tends to make formulas complex.

VLOOKUP would give a wrong result if you add/delete a new column in your data (as the column number value now refers to the wrong column). You can make the column number dynamic, but if you planning to combine two or more functions, why not use INDEX/MATCH in the first place.

When used on large data sets, it can make your workbook slow.