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.
Use VLOOKUP Function as an alternative to a number of nested IF functions.



Leave a Reply

Your email address will not be published. Required fields are marked *


× three = 9

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>