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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup problem 10
Formating bolded text exclusively. 0
Can I add a formula or function to Vlookup? 1
Help With VLOOKUP 2
VSTO C# add in Outlook.Appointment error 0
Same forumula returns both 0 & N/A 2
Incorporating the User Profile location into a document template path 1
Macro warning in word 1

Top