Results 1 to 12 of 12

IF cell is BLANK

Threaded View

  1. #1
    Registered User
    Join Date
    03-07-2018
    Location
    AUSTRALIA
    MS-Off Ver
    2010
    Posts
    11

    IF cell is BLANK

    Hi All,

    I need help with updating below formula. I need another criteria added to with "EMPLOYEE", I need it to look at another column (B)and return value only if its BLANK.


    =IFERROR(INDEX(Data_Entry!$B$3:$B$1000,SMALL(IF(Data_Entry!$A$3:$A$1000="EMPLOYEE",ROW(Data_Entry!$A$3:$A$1000)-ROW($A$3)+1,""),ROWS($A$3:A3))),"")

    File attached. First tab is how data is received, I need values to return in other tabs ie TEMPLATE_employee based on Classification and Sysytem id.

    Thanks!!!
    Last edited by AliGW; 03-15-2018 at 02:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. PLSSS Help, SUMIFS and IF
    By sarahbunny in forum Excel General
    Replies: 7
    Last Post: 11-17-2014, 10:26 PM
  2. Replies: 1
    Last Post: 08-08-2014, 07:53 AM
  3. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  4. Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  5. Hello everyone! and help plsss
    By kcgatchi in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 09-20-2012, 07:00 AM
  6. [SOLVED] Help Plsss
    By vmadan16 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2006, 08:15 AM
  7. [SOLVED] blank rows filling (Urgent)
    By Lolly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2006, 07:15 PM

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