+ Reply to Thread
Results 1 to 3 of 3

FIND function to find this value or if that isn't existing, find this value

  1. #1
    Registered User
    Join Date
    10-01-2020
    Location
    London, England
    MS-Off Ver
    365
    Posts
    78

    FIND function to find this value or if that isn't existing, find this value

    Hi Community,

    I'm sure his is fairly simple, but I can't bend my head around it.
    I have a cell that is filled with codes, up until a few days ago they were supplied in this format "A123_word word word"
    I used the "_" to get the "A123" using
    Please Login or Register  to view this content.
    Worked well, but now the supplier isn't always using an underscore. So I need to expand that and search for an underscore or a " 5G" (including the space).

    How can I amend this to accommodate?

    The full formula is more in depth as below
    Please Login or Register  to view this content.
    I have tried (among other things)
    Please Login or Register  to view this content.
    Thanks in advance.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: FIND function to find this value or if that isn't existing, find this value

    so, perhaps, you could try:

    =IF($BI4="","",IF(OR(BL4={"Deliveries","Materials","Warehousing"}),"VAR",IF(BX4="ADD","ADD",IF(ISNUMBER(SEARCH("36Grain",BL4)),"36Grain",LEFT(BL4,LOOKUP(9.99E+307,SEARCH({"_"," 5G"},BL4))-1)))))

  3. #3
    Registered User
    Join Date
    10-01-2020
    Location
    London, England
    MS-Off Ver
    365
    Posts
    78

    Re: FIND function to find this value or if that isn't existing, find this value

    Yes, I could try that.
    I did try that.
    It does output as needed.

    Brilliant support as usual.
    Thanks

+ 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. Replies: 0
    Last Post: 09-22-2018, 04:10 AM
  2. Replies: 1
    Last Post: 04-10-2017, 03:33 PM
  3. [SOLVED] Can I use FIND function to find specific string in a single cell?
    By bonpara in forum Excel General
    Replies: 2
    Last Post: 10-05-2015, 05:46 PM
  4. add in the parameters to the Find function to only find an exact match.
    By jakeembx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2014, 08:57 AM
  5. find function doesnt find imported info
    By dscott2479 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-12-2011, 07:11 PM
  6. Using find function to find entries in multiple cells
    By stanigator in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2007, 08:45 PM
  7. [SOLVED] Despite data existing in Excel 2002 spreadsheet Find doesn't find
    By AnnieB in forum Excel General
    Replies: 1
    Last Post: 06-15-2006, 09:15 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