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.


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


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