+ Reply to Thread
Results 1 to 4 of 4

Vlookup and ifblank

  1. #1
    Registered User
    Join Date
    12-04-2008
    Location
    Birmingham, UK
    MS-Off Ver
    Office 2007
    Posts
    43

    Vlookup and ifblank

    I have two workbooks containing details of a car fleet. I am using a simple vlookup to look at the vehicle registration on workbook 1 look it up in work book 2 and return the vehicle drivers name from a column.

    Everything works fine unless the lookup finds a blank cell in workbook 2 under the drivers name, where correctly it returns a blank.

    I would like to combine an if statement which says vlookup(workbook1!vehicleregistration,workbook2!columna:d,3,false(ifblank (workbook2!columna:d,4,false). I'm not sure of the correct syntax.

    Any help would be appreciated

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Vlookup and ifblank

    The requirements are not clear - generally better to outline requirements in narrative rather than via pseudo-formulae.

    Are you saying you want to

    a) have the blank return as a blank rather than 0 ?
    (as would be the case were the name a true blank)

    b) ignore the blank and find the first instance of the reg. that does contain a name ?
    (this assumes multiple instances of each reg. exist)

  3. #3
    Registered User
    Join Date
    12-04-2008
    Location
    Birmingham, UK
    MS-Off Ver
    Office 2007
    Posts
    43

    Re: Vlookup and ifblank

    Thanks for the response. I may be asking for the impossible or there may be another way of achieving this.

    What I want to do is where my look up finds a blank cell invoke a second look up which looks at the next column for the same registration.

    Hopefully this makes sense.........

  4. #4
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Vlookup and ifblank

    If I am understanding correctly

    Please Login or Register  to view this content.
    Last edited by ratcat; 03-16-2010 at 07:08 AM. Reason: Wrapping formula with the code
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

+ 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