Double Vlookup 2 vlookup

If you have data in two different table or worksheet then you need to apply double VLookup in MS Excel. At this condition most the Excel user faces lot of issue how to get the exact result which matches the condition. This article helps you to know how to use Excel Double VLookup function in active worksheet.

Syntax of VLookup function in Excel :- 

= VLookup (lookup_value, table_array, col_index_num, [range]) ENTRER

It function is used to search the value of extreme left column.

 

•   Lookup value is used to search in the extreme first column of the table array. You can give cell
• reference of a range or range name.
•  Col index numb is the column number in the table from which the searched value must bereturned.
•  Range lookup is an options part of this function. There are two options available in this part.
•  If range is TRUE then it will act just like appropriate match.
• When you Set Zero or False i.e. exact match. VLookup function by default check only on exact
• match method.

How to use Double VLookup in Excel

Must Read: It is reverse VLookup in Excel with VLookup Function

If you want to apply double VLookup in Excel sheets then you have to use given simple steps, have a look.

Example :-  =IFERROR(VLOOKUP(P90,$P$82:$Q$86,2,0),VLOOKUP(P90,$S$82:$T$86,2,0))