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.

ESAEO wrote:
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.

E.g., Range("range_name").Columns(3)

Alan Beban

Hi!

I would think, like it or not, you are best off defining the column as
a named range.

Alf