+ Reply to Thread
Results 1 to 6 of 6

Using IsBlank with VLookup

  1. #1
    Registered User
    Join Date
    01-07-2005
    Posts
    45

    Using IsBlank with VLookup

    I'm trying to return a specific value for all cells that are blank when doing a vlookup.

    So if I have my one sheet has the following data

    A B
    1 C 75
    2 F 86
    3 U
    4 I 43
    5 Q 49

    I want to pull the information on a new sheet, but if it's pulling for U (B3) then I want it to instead of giving a 0 to return with 100. How do I format my formula to do this?

    Thanks in advance.
    Last edited by odditie; 04-20-2011 at 10:18 PM.

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Using IsBlank with VLookup

    Hi,

    Are you looking for something like this?

    Please Login or Register  to view this content.
    abousetta

  3. #3
    Registered User
    Join Date
    01-07-2005
    Posts
    45

    Re: Using IsBlank with VLookup

    Quote Originally Posted by abousetta View Post
    Hi,

    Are you looking for something like this?

    Please Login or Register  to view this content.
    abousetta
    That's what I tried but then it returns "#NAME?"

  4. #4
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Using IsBlank with VLookup

    Are you sure you typed the formula correctly? Have a look at the attachment.

    abousetta
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-07-2005
    Posts
    45

    Re: Using IsBlank with VLookup

    Thanks for the help, I found my error, in my actual formula I was trying to get it to return text but I didn't use quotes around it.

  6. #6
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Using IsBlank with VLookup

    I had a feeling you were doing that but didn't want to jump the gun. It's a common problem.

    Glad I could help.

    If you are satisfied with the results, please mark the thread as SOLVED.

    Good luck.

    abousetta

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1