Adv. Excel Formulas

VLOOKUP formula in excel

VLOOKUP FUNCTION IN DETAILS

VLOOKUP- stands for (Vertical Lookup). this function makes Excel search for a certain value in a column (table array), in order to return a value from a different specified column in the same row

In below simple Vlookup example we find subject score based on name –

  • Insert formula in cell C11 as we need result here.
  • We have taken cell no B11 for searching product name (Lookup_Value),
  • Then select table area where from to search data(Table_Array)
  • Now define which column data to be find(col_index_num).
  • 0=False (Exact match) | 1=True (Approximate match)

VLOOKUP Function: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

VLOOKUP with index match-

With this vlookup can search data depend upon two queries.

Same as previous section we will set function in C11 cell.

=VLOOKUP(B11,$B$2:$G$8,MATCH(C10,$B$1:$G$1,0),0)

In this example we will find out result of any student of any subject using vlookup and index match function.

  • Select cell where you want to get result
  • Use VLOOKUP function and specify cell range and criteria to find a data.
  • now use Index Match and specify subject area.

Open Spreadsheet for practice: CLICK HERE

Leave a Reply

Scroll to Top

Institute Registration

National Program for Information Technology & Skill Development


Address of your academy:


Submit Documents


Documentation Fee