+ Reply to Thread
Results 1 to 7 of 7

Multiple vlokup

  1. 07-15-2014, 11:42 AM #1
    webisti
    webisti is offline
    Registered User
    Join Date
    11-26-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    12

    Multiple vlokup

    Hi
    I am trying to create a multiple vlookup but with no success.
    Here is what I do have:
    One sheet named "team" where I have a table:
    Team Name
    Team1 adam
    Team1 ecole
    Team1 nicole
    Team2 gerry
    Team2 nicol
    Team2 diana
    Team3 stefan
    Team3 cler
    Team3 Clara
    Team3 Daniel
    Team4 dana
    Team4 deri
    Team4 jerry
    Team4 nika
    Team4 pika


    on the other sheet named Partecipants I want to have a result like:

    Team Name
    Team1 adam ecole nicole n/a n/a
    Team2 gerry nicol diana n/a n/a
    Team3 stefan cler Clara n/a n/a
    Team5 Cleri Denis n/a n/a n/a
    Team4 dana deri jerry pika Nika

    How can I do that with a vlookup? Or any other way?

    I know it must be easy. but my brain is having a black out...
    any ideas?

    Webisti
    Reply With QuoteRegister To Reply
  2. 07-15-2014, 12:04 PM #2
    alansidman
    alansidman is online now
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    23,959

    Re: Multiple vlokup

    See the attached spreadsheet that has a UDF enclosed.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 07-15-2014, 12:08 PM #3
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Multiple vlokup

    Hi Websiti...
    got the solution..

    Check the attachment..




    Don't forget to click *
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-18-2014, 04:48 AM #4
    webisti
    webisti is offline
    Registered User
    Join Date
    11-26-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Multiple vlokup

    Hi I tried both version but without success. As to make is simple here is my file that I want to use.

    mupltiple.xlsx
    Can you have a look and make it possible to apply your ideas? The problem I found on the formula is that it does not properly work if data is on different sheets. I want the Team sheet data to be on the main sheet as seen on the sample file.
    Hoe can I do that sing a formula, where the teams will always have different number of players up to 80 for ex.
    Do not ask for the logic behind why, I also do not know, but the result should be on the main sheet, showing for each team their respective players on a horizontal level. I tried to do that with a pivot table, but is quite manual, I thought that a clever formula could do the job for me.
    any ideas

    Regards

    Webisti
    Last edited by webisti; 07-18-2014 at 07:27 AM.
    Reply With QuoteRegister To Reply
  5. 07-21-2014, 07:25 AM #5
    webisti
    webisti is offline
    Registered User
    Join Date
    11-26-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Multiple vlokup

    So anyone has any idea? I am still lost.

    Webisti
    Reply With QuoteRegister To Reply
  6. 07-21-2014, 08:00 AM #6
    windy58
    windy58 is offline
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: Multiple vlokup

    The solution in post 3 does work it just needs adapting to suit your requirements.

    See attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 07-21-2014, 08:38 AM #7
    Hawkeye16
    Hawkeye16 is offline
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Multiple vlokup

    And if you want the n/a instead of blank for empty spots just switch out the last "" in the formula with "n/a"
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] SUM with Vlokup returning #NAME
    By Dibbley247 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-30-2014, 01:31 PM
  2. Copy multiple values from multiple worksheets from multiple workbooks - with a twist
    By bk34 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-13-2013, 04:15 PM
  3. Vlookup if blank do vlokup to a different column
    By Mark O'Loughlin in forum Excel General
    Replies: 11
    Last Post: 04-14-2011, 08:02 PM
  4. Multiple Year, Multiple Consultant, Multiple Client Calendar with multiple views
    By JulianT in forum Excel General
    Replies: 5
    Last Post: 11-04-2010, 06:02 AM
  5. VLokup Not Recognizing Data
    By blakrapter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2008, 08:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1