Results 1 to 4 of 4

Take data from array, insert into string, search for string in another array

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2014
    Location
    Central Texas
    MS-Off Ver
    Excel 2010
    Posts
    55

    Question Take data from array, insert into string, search for string in another array

    Hey ya'll,
    I'm looking for a single-cell formula for a simple / efficient way to take data from one array, put it in between two other sets of data and do a search in a second array for that completed string.
    Basically, I'm trying to take numbers from a list (one at a time), place them between a pre-designated Month-number and year to create a date. Then make a search in a second array for that date. The search needs to be performed for every date created from the first array.
    All I can come up with is an IF / CONCATENATE conglomeration that would take days to enter all the dates I need to search for. Also, that IF / CONCATENATE conglomeration keeps coming up a(n) #VALUE! error . Apparently, SEARCH does not like dates, or something. That code is as follows (it only has two dates for the example, but there's many more):
    =IF(SEARCH(OR(CONCATENATE("5/",A1,"/2015"),CONCATENATE("5/",A2,"/2015")),D1:D12)>=1,1,0)
    There is some instruction on the included example sheet, if anything is unclear. I have a desired result (K7) for the complete formula. Array 1 takes A1:A7, array 2 takes D1:D12.
    What the formula is to do is in G1 (long drawn-out process), with the result below it in K7.

    Any help or a Point-in-the-right-direction would be greatly appreciated.

    Please & Thank ya'll!
    Attached Files Attached Files
    Oh! I get it. I need rep--->҉

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search for a string of numbers within an array
    By Chubster in forum Excel General
    Replies: 2
    Last Post: 09-06-2014, 09:22 PM
  2. VBA Find Partial String in String Array and Output the Found String Array Value
    By scherich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2014, 11:20 AM
  3. Replies: 4
    Last Post: 12-23-2013, 08:43 AM
  4. [SOLVED] Return matching string in array if cell contains string contained in the array
    By AaronsZ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2013, 01:55 PM
  5. search for a part of string within an array of strings from another array list
    By jdonohue in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2011, 01:32 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