» Use VLOOKUP Function as an alternative to a number of nested IF functions.

Problem:

Excessive number of nested IF Functions are difficult to manage

Example:
=IF(C2=1,100,IF(C2=1,200,IF(C2=2,300,IF(C2=3,400,"Not available"))

Solution:

An alternative technique is to enter the conditions in a range and use the VLOOKUP function to retrieve the particular value.

Example:
=VLOOKUP(C2,A1:B5,2,FALSE)

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.