Identifying single column within named range
How do I specify a single column of a multi-column named range within an
argument in an IF statement? This multi-column named range works perfectly
in a VLOOKUP but IFs need only a single column. I'd like to NOT have to
define yet another range nor use longhand cell reference.
|