Simple VLookUp Formula for Excel

VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a particular value in a column (the so-called ‘table array’) to return a value from a different column in the same row.  In other words, the VLOOKUP function is a premade function in Excel, which allows searches across columns. Here is the formula of a simple VLOOKUP for two columns.

=VLOOKUP(C2,C5:D17,2,TRUE)

If you want to drag the formula cell below, first insert dollar sign between cell and row reference. So, the formula will be

=VLOOKUP(C2,$C$5:$D$17,2,TRUE) 

You can be doing this by selection C5:D17 in formula and press F4 key.