VLOOKUP Function :
Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row.
Syntax :
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
Description:
=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE).
Example : Address Book
Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row.
Syntax :
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
Description:
=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE).
Example : Address Book
Formulas :
Name : =VLOOKUP(C2,A10:D13,1,FALSE)
Mobile Number : =VLOOKUP(C2,A10:D13,2,FALSE)
Email : =VLOOKUP(C2,A10:D13,3,FALSE)
Address : =VLOOKUP(C2,A10:D13,4,FALSE)
Follow @Sarvavasi.com