Results 1 to 7 of 7

Thread: Vlookup with a Vlookup?

  1. #1

    Vlookup with a Vlookup?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Guys,

    Thank you for taking time to read this.

    I have a problem, I want to do vlookup of cell H2 (which is a drop down list) but pull over the data from the sub table containing the list of sports, if that makes sense?

    I have attached the spreadsheet and screenshot if that helps.

    I want to be able to change cell H2 (the region) and have cells J2:K7 (the highlighted cells) to change accordingly to the region selected, is this possible?

    Iíve been racking my brains all yesterday and just canít seem to figure it out! Please help

    Maybe vlookup is not the way to go, any advice or solutions would be soooo helpful, thank you all x
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Sport Pic.jpg 
Views:	17 
Size:	39.2 KB 
ID:	1250  
    Attached Files Attached Files

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,313
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Is the attached what you need?Copy of Sport.xlsx

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    766
    Articles
    0
    Excel Version
    2010
    This array formula may do the trick:

    {=IFERROR(INDEX(B$19:B$99,SMALL(IF($B$19:$B$99=$J$18,ROW(B$19:B$99)-18),ROW(B1))),"")}

    This allows you to find instances of a search value in a separate table, and extract other detail from the matching entries (Like a database search). Its status as an array formula is indicated by the curly braces around the formula. You can't type these in directly - you have to complete the formula and then press Control+Shift+Enter to get Excel to put them in for you. Also, you need to repeat this each time you edit the formula.
    Ive produced an example that gets employee data from a larger table based on a drop down selection in cell J18
    Have a look at it and see if it helps

    Hercules
    Attached Files Attached Files

  4. #4
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Look Ma, no formulas...Sport_Jeff.xlsx

  5. #5
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    766
    Articles
    0
    Excel Version
    2010
    Hi
    Ive adapted my example earlier to provide what you want, so you have 3 ways to do it !

    Hercules
    Attached Files Attached Files

  6. #6
    Quote Originally Posted by Pecoflyer View Post
    Is the attached what you need?Copy of Sport.xlsx
    Thanks everyone for your help, this one seemed the easiest to follow Thank You

  7. #7
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    766
    Articles
    0
    Excel Version
    2010
    Glad you found a solution - Provided that you keep the records in your table in the same order the solution you picked will work fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •