The formula checks if the criteria meets, thus returning the first argument of IF(), otherwise, the second argument is returned. continuing with this we have VLOOKUP() formula that will return results from the respective range of values.
Specifies a logical test to perform
IF(Something is True, then do something, otherwise do something else)
Category: Lookup and reference
Looks in the first column of an array and moves across the row to return the value of a cell
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM