IF(...)
How to use IF() with VLOOKUP()
Used Functions
Category: Logical
Specifies a logical test to perform
Syntax
IF(Something is True, then do something, otherwise do something else)
Practice IF Formula at Sheetzoom
IF formula at Microsoft helpCategory: Lookup and reference
Looks in the first column of an array and moves across the row to return the value of a cell
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
0
The formula works by testing the provided conditions, if the statement is true, the first argument (first vlookup) is returned. Otherwise second argument (i.e. second vlookup) is returned.