Categories
Usage & tips
VLOOKUP
VLOOKUP 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.
IF
The IF function in Excel performs a logical comparison between two values. The result of the IF function is either TRUE or FALSE.