Identifying single column within named range

E

ESAEO

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.
 
A

Alan Beban

ESAEO said:
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.
Click to expand...

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

Alan Beban
 
A

AlfD

Hi!

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

Alf
 
Top