Results 1 to 6 of 6

Find Formula to search "Approx match"

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Find Formula to search "Approx match"

    I have this formula on a large sheet that I need a way for it to find "approx matches" (without rewriting the entire formula)

    So would anyone have an idea how to rewrite this to find anything with OFF in the name?

    Here is the formula, i will have other names (with using OFF in them) so this is what I need to find APPROX Match


    =IF('P1'!$U$13="SICK","",IF('P1'!$U$13="OWED","",IF('P1'!$U$13="OFF","",IF('P1'!$U$13="REQ OFF","",IF('P1'!$U$13="LOA","",IF('P1'!$U$13="VACA","",IF('P1'!$U$13>1,"X","")))))))
    Last edited by g1terra; 11-21-2017 at 01:13 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. i need to find a formula to find the top three values in a column
    By silentscribbles in forum Excel General
    Replies: 1
    Last Post: 11-07-2017, 04:07 AM
  2. Replies: 1
    Last Post: 04-10-2017, 03:33 PM
  3. Replies: 3
    Last Post: 09-12-2016, 01:44 PM
  4. Replies: 5
    Last Post: 06-07-2014, 09:54 AM
  5. [SOLVED] Trying to find a formula to find a random $ amount in a text in a cell
    By Miki1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2013, 10:13 PM
  6. IF formula to find a word but Not find a certain phrase
    By byrdjulie in forum Excel General
    Replies: 2
    Last Post: 02-03-2011, 05:18 AM
  7. Find Formula needs to find jobs with split names
    By 3smees23 in forum Excel General
    Replies: 5
    Last Post: 08-06-2009, 08:18 AM

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