• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup with a Vlookup?

loverheart23

New Member
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
 
Back
Top