Results 1 to 6 of 6

Loop formula to search through range to get expected output

Threaded View

raj2989 Loop formula to search... 02-14-2014, 09:16 AM
azumi Re: Loop formula to search... 02-14-2014, 09:24 AM
raj2989 Re: Loop formula to search... 02-14-2014, 09:50 AM
azumi Re: Loop formula to search... 02-14-2014, 10:34 AM
raj2989 Re: Loop formula to search... 02-17-2014, 07:36 AM
azumi Re: Loop formula to search... 02-17-2014, 09:15 AM
  1. 02-14-2014, 10:34 AM #4
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Loop formula to search through range to get expected output

    Please check the fles, something like this....

    =IF(ISERROR(LOOKUP(2^15;SEARCH(TRIM(LEFT(A2;SEARCH(" ";A2;SEARCH(" ";A2;1)+1)));$C$2:$C$7);$C$2:$C$7));"Others";LOOKUP(2^15;SEARCH(TRIM(LEFT(A2;SEARCH(" ";A2;SEARCH(" ";A2;1)+1)));$C$2:$C$7);$C$2:$C$7))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Expected Do before loop (compile error)
    By Rokn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-08-2013, 07:35 PM
  2. Formula to search column for match and output date in corresponding row
    By bpartin13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2013, 12:52 AM
  3. Loop to find a criteria within range, then output results to individual lines
    By bologne in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-17-2011, 12:30 PM
  4. Excel 2007 : Excel 2007 Reverse the Expected Output
    By robinx1578 in forum Excel General
    Replies: 6
    Last Post: 09-19-2009, 07:45 AM
  5. [SOLVED] Search range of cells, find a value, output adjoining cell. How?
    By nyys in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2006, 09:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1