+ Reply to Thread
Results 1 to 2 of 2

Blank cell for find and match

  1. #1
    Registered User
    Join Date
    04-13-2016
    Location
    canada
    MS-Off Ver
    2010
    Posts
    35

    Blank cell for find and match

    Hi,

    Require assistance with below fomula

    1. If cell K2 is blank OR not exact match - Require L2 to be blank


    Have below fomula in cell L2

    [CODE=IF(ISNONTEXT(FIND($K2,MasterList!$A$3:$A$10001)),INDEX(MasterList!G$3:G$10001,MATCH("*"&$K2&"*",MasterList!$A$3:$A$10001,0)),"")[/CODE]

    Tried

    =IF(ISNONTEXT(FIND($K2,MasterList!$A$2:$A$10000)),INDEX(MasterList!B$2:B$10000,MATCH("*"&$K2&"*",MasterList!$A$2:$A$10000,0)),"",FIND($K2,MasterList!$A$2:$A$10000)),INDEX(MasterList!B$2:B$10000,MATCH("*"&$K2&"*",MasterList!$A$2:$A$10000,0)))

    doesn't work

    USING EXCEL 2016

    Thanks in advance

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Blank cell for find and match

    use # or fx from menu instead of manually entered tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need Index/Match to find the first non-blank cell and return the value in the top row
    By royalbluestuey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2018, 01:43 PM
  2. Index/ Match Formula, How to return blank cell as a blank not 0
    By MDResearcher in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-24-2016, 08:40 PM
  3. Find a match if not blank
    By tharindudk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2015, 01:33 AM
  4. Match function doesn't find BLANK cells?
    By ssudekum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2014, 07:35 PM
  5. [SOLVED] Find first non-blank cell after a group of blanks copy offset cells, find next blank, loop
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-21-2012, 06:11 AM
  6. Find a blank cell and calculate the average of all cells above till the next blank
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 11:51 AM
  7. Can I use the Match Function to find a blank cell?
    By RevJeff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2011, 09:54 AM

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