Simple VLookUp Formula for Excel
VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so-called ‘table array’), in order 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)