VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))
 
Named range 'Database' doesn't include 218 columns?

Redefine Database to include the needed column.
 
Back
Top