#index-match

Follow to get notified about new posts with this tag

magnacarta

nested-if-rewrites

5y

Summary of the 8 Nested IF() Rewrites

Summary of the 8 Nested IF() Rewrites

There are numerous ways of rewriting convoluted nested IF()s, only 8 of which are covered here to accommodate versions of Excel going back to 2000. Some rewrites use just 1 function. VLOOKUP() is the

$ 0.000

0

magnacarta

nested-if-rewrites

5y

Rewrite #3: INDEX-MATCH

Rewrite #3: INDEX-MATCH

Excel syntax for INDEX(): =INDEX(array, row_num[, column_num]) Excel syntax for MATCH(): =MATCH(lookup_value, lookup_array, [match_type]) Syntax for INDEX-MATCH: =INDEX(array, MATCH(lookup_value, lookup_array,

$ 0.000

0