Results 1 to 12 of 12

Multiple lookup solution needed...

Threaded View

Nick312 Multiple lookup solution... 09-21-2017, 09:33 PM
jindon Re: Multiple lookup solution... 09-21-2017, 09:45 PM
Nick312 Re: Multiple lookup solution... 09-21-2017, 09:48 PM
Nick312 Re: Multiple lookup solution... 09-22-2017, 11:45 AM
jindon Re: Multiple lookup solution... 09-22-2017, 07:40 PM
Nick312 Re: Multiple lookup solution... 09-22-2017, 08:35 PM
jindon Re: Multiple lookup solution... 09-22-2017, 09:05 PM
Nick312 Re: Multiple lookup solution... 09-22-2017, 11:43 PM
jindon Re: Multiple lookup solution... 09-22-2017, 11:46 PM
Nick312 Re: Multiple lookup solution... 09-23-2017, 11:36 AM
jindon Re: Multiple lookup solution... 09-23-2017, 05:33 PM
Nick312 Re: Multiple lookup solution... 09-25-2017, 11:52 AM
  1. #1
    Registered User
    Join Date
    09-21-2017
    Location
    Chicago
    MS-Off Ver
    365
    Posts
    10

    Multiple lookup solution needed...

    Hey all, I've run into a stumper, well for me.

    I am currently running the SingleCellExtract VBA (below) to present all column 2 entries for matches to column 1. My issue lies that every 2 column list has thousands of entries and so running the extract take hours and hours. Does anyone know 1. a better solution to look through the data and relay what I'm looking for and 2. that solution could be "living" so when new entries are added everything "refreshes".

    This is the code I'm running:

    Function SingleCellExtract(LookupValue As String, LookupRange As Range, ColumnNumber As Integer, Char As String)
        Dim I As Long
        Dim xRet As String
    Application.ScreenUpdating = False
    
        For I = 1 To LookupRange.Columns(1).Cells.Count
            If LookupRange.Cells(I, 1) = LookupValue Then
                If xRet = "" Then
                    xRet = LookupRange.Cells(I, ColumnNumber) & Char
                Else
                    xRet = xRet & "" & LookupRange.Cells(I, ColumnNumber) & Char
                End If
            End If
        Next
        SingleCellExtract = Left(xRet, Len(xRet) - 1)
    Application.ScreenUpdating = True
    End Function
    example of Data:
    Cell A - Cell B - Cell C (were formula/code is running)
    12345 - 9.15.16 - 9.15.16, 10.2.16
    67890 - 9.16.16 - 9.16.16, 10.3.16
    12345 - 10.2.16 - 9.15.16, 10.2.16
    67890 - 10.3.16 - 9.16.16, 10.3.16

    I appreciate any help with speeding this up, the first project took 12 hours to complete column C.
    Thanks! Nick.
    Last edited by Nick312; 09-21-2017 at 09:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multiple lookup and countif solution required to show results as a table.
    By reddaze in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2017, 10:23 AM
  2. Vlookup Solution Needed
    By sjpras in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2015, 05:58 AM
  3. Countif Solution Needed
    By khangmg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2012, 04:55 PM
  4. VBA Concatenate Solution needed
    By Dean England in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2007, 09:26 AM
  5. Lookup solution needed
    By drucey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2006, 12:13 PM
  6. Sort Solution needed
    By Patrick Simonds in forum Excel General
    Replies: 2
    Last Post: 03-16-2005, 08:06 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