Results 1 to 5 of 5

If two cells are blank then return blank, else vlookup cell with populated data

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2016
    Location
    Cleveland, OH
    MS-Off Ver
    2010
    Posts
    16

    If two cells are blank then return blank, else vlookup cell with populated data

    Need a hand .. I'm stumped and don't know why:

    Existing formula IF(ISBLANK(D4:D5)," ",IFERROR((IF(ISBLANK(D4),VLOOKUP(D5,'Master List'!B:O,14,0),VLOOKUP(D5,'Master List'!D:O,12,0))),"Not TSRd"))

    1. If D4 and D5 are empty, then in D6 return blank
    2. If d4 is not empty, vlookup d4 on master list and return TSR date in D6
    3. if d5 is not empty, vlookup d5 on master list and return TSR date in D6
    4. If D4 or D5, when entered are not found in the master list, return "Not TSRd"

    Thank you in advance for your input!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-22-2016, 04:03 PM
  2. [SOLVED] Cells in a range are all not blank, return maximum value (date), If 1 blank return 0
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2016, 11:14 AM
  3. Return first non blank cell (cells have formulas that return blank)
    By BG1983 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2016, 04:06 PM
  4. Replies: 3
    Last Post: 02-09-2015, 09:00 AM
  5. Delete Cells with Specific Value and All Blank Cells Until Next Populated Cell is Checked
    By rdtrahan1906 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2014, 05:50 PM
  6. [SOLVED] Need formula to return blank instead of #N/A when source cell is blank, using VLOOKUP
    By TMB1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2013, 07:16 PM
  7. Return Blank Cell if Sum Cells Blank or Zero
    By Battledeck in forum Excel General
    Replies: 6
    Last Post: 06-11-2012, 05:55 PM

Tags for this Thread

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