Results 1 to 8 of 8

Help adding ISBLANK to LOOKUP formula

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2019
    Location
    Devon
    MS-Off Ver
    Office 365
    Posts
    19

    Question Help adding ISBLANK to LOOKUP formula

    Hi Everyone.

    I'm hoping someone can help or point me in the right direction to find the solution. I am using the below formula to extract a list of unique entries to Column D from a range in Column A:

    =LOOKUP(2/1(COUNTIF($D$3:$D$3,$A$4:$A$304)=0),$A$4:$A$304)

    Sometimes there could be 10 unique entries, sometimes there might be 20 in a dynamic list with space for 30 entries. This leaves cells in my unique entry list that don't get populated with a #N/A..... Unfortunately it is setting my OCD on fire!!

    I have tried the following to clean this up and leave the unpopulated cells blank but it gives me a circular cell reference:

    =IF(ISBLANK(D3),"",LOOKUP(2/1(COUNTIF($D$3:$D$3,$A$4:$A$304)=0),$A$4:$A$304)) - This was a bit of guessing on my part as to how the formula should look.

    I know really I need the formula in another cell and looking more and more at my guess work I'm realising that it needs to perform the LOOKUP logic test first and then leave the cell blank if there are no further unique entries. I thought maybe using IFNA I could achieve this but I'm not sure where to nest this in the formula or the right syntax and structure to do it.

    Any help would be greatly appreciated.

    Thanks in advance
    Last edited by NonEventHorizon; 07-04-2019 at 09:55 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Clean up If/Then formula, adding in "isblank" range
    By snuffnchess in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-08-2016, 02:16 PM
  2. [SOLVED] lookup and adding formula
    By lstevenson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2014, 09:28 PM
  3. Help with adding ISBLANK to a VLOOKUP function
    By llubelczyk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2014, 02:10 PM
  4. PLEASE HELP: ISERROR, ISBLANK with LOOKUP
    By NoJokenVA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2013, 04:45 PM
  5. Adding Conditional Formatting to =if(isblank(2E),1,0)
    By amyflowersteam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-27-2013, 01:26 PM
  6. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM
  7. Adding A Not(IsBlank) To IF Statement(help)
    By getmhawks in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2006, 05:50 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