Results 1 to 4 of 4

Thread: Excel vertical search, Multiple results per id

  1. #1
    Join Date
    Jan 2009
    Posts
    36

    Excel vertical search, Multiple results per id

    My question is about vertical search excel.

    I would like to want to link IDs and user names that appear in a cell. Only these IDs / numbers associated with multiple user names.

    At this moment I am where I get 1 per user id, but I would like to thank all the user names to get in 1 cell. My question is: Is this possible and if so how?

    Thanks.

  2. #2
    Dr. V Guest

    Re: Excel vertical search, Multiple results per id

    try this
    Public Function vlookupall$(strSearch As String, rngRange As Range, lngLookupCol As Long)

    'Vlookupall searches in first column of rngRange for strSearch and returns corresponding
    'values of column lngLookupCol if strSearch was found. All corr. values are collected and
    'returned in one string (result of function).

    Dim i As Long

    If lngLookupCol > rngRange.Columns.Count Then
    vlookupall = CVErr(xlErrValue)
    Exit Function
    End If

    vlookupall = ""

    For i = 1 To rngRange.Rows.Count

    If rngRange(i, 1).Text = strSearch Then

    vlookupall = vlookupall & rngRange(i, lngLookupCol).Text & "; "

    End If

    Next i

    End Function

  3. #3
    Join Date
    Dec 2008
    Posts
    322

    Re: Excel vertical search, Multiple results per id

    you can use above vbn script or check this http://office.microsoft.com/en-us/ex...260381033.aspx

  4. #4
    Join Date
    Dec 2008
    Posts
    196

    Re: Excel vertical search, Multiple results per id

    Use this function on an acct number in your table, =ISNUMBER(A1). If it is a true value/number then the function will return TRUE. If not then it returns FALSE. Then use your CONCATENATE part of your formula to get just the combination of the numbers you are putting together to "build" an acct number and put that in a cell by itself, like B1. Then use =ISNUMBER(B1). If it returns FALSE then you will see the problem. VLOOKUP needs both to be the same so it can find what it is looking for.

    Also, you don't need to use the CONCATENATE function at all. You can just use =A1&B1&C1, for example. And finally I have many suggestions to make your file smaller and thus calculate faster and open and save faster as well.

Similar Threads

  1. in. search-results as search engine instead of Google
    By Eseld in forum Networking & Security
    Replies: 5
    Last Post: 15-07-2011, 07:23 PM
  2. Replies: 6
    Last Post: 08-06-2011, 11:36 PM
  3. IE9 Search Taking Me to Web Pages Rather Than Search Results
    By Mishraji in forum Technology & Internet
    Replies: 3
    Last Post: 14-10-2010, 05:07 PM
  4. Replies: 5
    Last Post: 10-10-2010, 04:30 AM
  5. Replies: 2
    Last Post: 27-06-2009, 01: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
  •  
Page generated in 1,696,473,266.88742 seconds with 17 queries