Vlookup function in excel

Fix your VLOOKUP in Excel

VLOOKUP stands for vertical lookup. This function works well with a standard table layout that has a code, or value, in the left column of the table. The other columns in the table can be accessed by “looking up” the code or value in the left column.

Most issues relate to the data table, especially when it is imported from other systems. The exact match type of VLOOKUP is the one usually affected. You specify an exact match by including FALSE or a zero at the end of the VLOOKUP function.

Examples from cell B2 in Figure -

=VLOOKUP(A2,D2:E5,2,0)

=VLOOKUP(A2,D2:E5,2,FALSE)