+ Reply to Thread
Results 1 to 9 of 9

VLookup that Results with False or Blank Results

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,052

    Question VLookup that Results with False or Blank Results

    Hi,

    I'm using a Vlookup into another worksheet with the following function:


    =IF(T42="","",VLOOKUP(T42,'Tracking'!B:F,5,FALSE))

    In the look up cell, there is no data or the cell is (intentionally) blank.

    I was thinking I can use something like this, which works if looking at the specific cell, H2302:

    =IF(T42="","",IF('Tracking'!H2302="","",VLOOKUP(T42,'Issue Tracking'!B:H,7,FALSE)))

    However, I do not want "lock onto" this cell because T42 cell data will constantly change.


    How can modify this Vlookup function to give a blank result if the look up cell is also blank?


    Thanks
    MyCon
    -- Using Latest Version of Excel

  2. #2
    Forum Contributor ragavan.sridar1's Avatar
    Join Date
    11-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010, Excel 2003
    Posts
    208

    Re: VLookup that Results with False or Blank Results

    try using =IfError(IF(T42="","",IF('Tracking'!H2302="","",VLOOKUP(T42,'Issue Tracking'!B:H,7,FALSE))), " ")
    Last edited by ragavan.sridar1; 03-12-2013 at 02:17 PM.
    Thanks!
    Raga.

    Please,mark your thread [SOLVED] if you received your answer.

    Click the little star * below, to give some Rep if you think an answer deserves it.

    I learnt so many things from these links.

  3. #3
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: VLookup that Results with False or Blank Results

    The above solution can be tidied up as below:

    Please Login or Register  to view this content.
    The IF statement checking T42 is made redundant with the use of IFERROR as this covers the situation of a 'blank' in T42.
    Say thanks, click *

  4. #4
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,052

    Re: VLookup that Results with False or Blank Results

    Hi,

    Perhaps, this will help:

    I have a large database that constantly gets updated.

    I am looking up a list of job numbers from the Master log sheet.

    Once I find the job number, I want to copy all the data across the rows.

    How can I do this?

  5. #5
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,052

    Re: VLookup that Results with False or Blank Results

    Hi,

    This function works well until it "sees" a blank cell:

    =IF(T42="","",VLOOKUP(T42,'Tracking'!B:F,5,FALSE))


    This function also works well:
    =IFERROR(IF('Tracking'!H2302="","",VLOOKUP(T42,'Issue Tracking'!B:H,7,FALSE)),"")

    However, I don't always want to reference cell h2302 because the primary cell it's referencing - the Project number may move up or down on the master log column.


    Can this be modified be modified to work like the Vlookup?

    Thanks

  6. #6
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    Re: VLookup that Results with False or Blank Results

    Is it finding a match for the value in T42 in the sheet Tracking in column B? if so what if in column F of that row?
    Tom S.
    ↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the left
    If your question is resolved, mark it SOLVED using the thread tools.

  7. #7
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: VLookup that Results with False or Blank Results

    Upload an example spreadsheet with expected results to help explain what exactly you need please.

  8. #8
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,052

    Re: VLookup that Results with False or Blank Results

    Hi,

    Per your request, I uploaded an example file.

    In this file, you will see 2 worksheets as follows:

    * Tracking - Suppose to represent the master data log
    * Back Log Review - Selected few copy of WPs or Work Packages that may be open & closed to be re-reviewed & may be re-ordered per Assigned Date.


    Requesting assistance to get same data or "blank" results as it is in the Master log. I am using the Backlog Review worksheet to manipulate priorities of WPs.


    Thanks
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    Re: VLookup that Results with False or Blank Results

    Try this
    Please Login or Register  to view this content.

+ 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