VLOOKUP

R

Robbyn

Good evening all,

Why does the following formula work:

=IF(ISBLANK(VLOOKUP($B$1,Database,217,0)),"",VLOOKUP($B$1,Database,217,0))

But this one doesn't (I get a #REF error):

=IF(ISBLANK(VLOOKUP($B$1,Database,218,0)),"",VLOOKUP($B$1,Database,218,0))
 
J

JLatham

Named range 'Database' doesn't include 218 columns?

Redefine Database to include the needed column.
 
Top