Excessive number of nested IF Functions are difficult to manage
An alternative technique is to enter the conditions in a range and use the VLOOKUP function to retrieve the particular value.
1- The first arguments of the VLOOKUP Function look in the first column of range A1:B5 for the value contained in cell C2.
2- The result value returns from the second column of the range.
Screenshot // Use VLOOKUP Function as an alternative to a number of nested IF functions.
Use VLOOKUP Function as an alternative to a number of nested IF functions.