Thanks, saving a click, not going for the article; not that it's necessarily bad or uninteresting; not that I wouldn't if I had more time on this planet.
Didn't Excel gain the ability to use names at some point?
Is 'anominal' a word? As in 'anominal' or 'non-nominal' programming, or 'un-' or 'dis-'. Maybe Excel rises to 'pseudonominal'.
--- quote ---
Most users would use below nested IF function
=IF(B2=$F$3,$G$3,IF(B2=$F$4,$G$4,IF(B2=$F$5,$G$5,IF(B2=$F$6,$G$6,IF(B2=$F$7,$G$7,IF(B2=$F$8,$G$8))))))
Didn't Excel gain the ability to use names at some point?
Is 'anominal' a word? As in 'anominal' or 'non-nominal' programming, or 'un-' or 'dis-'. Maybe Excel rises to 'pseudonominal'.
--- quote ---
Most users would use below nested IF function
=IF(B2=$F$3,$G$3,IF(B2=$F$4,$G$4,IF(B2=$F$5,$G$5,IF(B2=$F$6,$G$6,IF(B2=$F$7,$G$7,IF(B2=$F$8,$G$8))))))