Advanced-VLookup

Lookup Multiple Fields of Data with Excel VLOOKUP

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

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

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

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.

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

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.

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.

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.