Advanced-VLookup

Advanced VLookup trick with Data Validation in Excel

If you have any complex criteria then you can use VLookup trick with Data validation. It allows you to search value as per given condition.

VLookup in reverse order allows you to lookup any value from right to left side. Lookup a value in reverse order use Index & Match function.

VLookup and Sum function in Excel allows you to quickly get the total of more than one columns values which match the given lookup value.

You can lookup the matched different column values in active worksheet. To get the result use VLookup to return multiple column values.

If you have more than one columns and want to use VLookup Find first, 2nd Or Nth match value then you can use VLookup with IFError function.

If you need to combine two VLookups into one VLookup function to get the result. This guide helps you how to use double VLookup in Excel sheet

VLookup Match located Lookup & reference category it’s important & advance function which allow to perform a matrix lookup than normal lookup

Sometime we need to lookup multiple fields of data with Excel VLOOKUP function. You can use Columns or Column or array with VLookup function.