# 想問係 Excel 既 v look up formula

Rating

Say like you have a table

cell A1: Student ID

cell B1: Student Name

cell C1: Student date of birth

cell A2: 1001

cell B2: Chan

cell C2: June 12th

cell A3: 1002

cell B3: Lee

cell C3: April 17th

say you want to lookup student name by referring to their student ID,

so you put [1001] in cell F1

and then put a vlookup formula in cell G1

=vlookup(F1,A:C,2,false)

Explanation of the formula:

F1 - refers to the lookup value, in this case is [1001]

A:C - refers to lookup range, usually is the range of the table

2 - refers to the lookup column in the table , if you put [1], it will look at column 1, if you put [3] it will look at column 3 , which is the date of birth

false - means find exact match , true will be the closest match of the lookup column

in vlookup, the lookup value has to be the left most column in the table, if you switch the order of the column , you have to adjust the lookup formula.

Besides vlookup, there's lookup and hlookup , but vlookup is the most common one.

let me know if you have any question.