• 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.

Help Please!!

V

Veronica Garay

New Member
I'm lost, I've been working on this spreadsheet for days. I have a data page on my spreadsheet housing a table with specific data (Table1 cells O27-AA47). On my dash page I'd like to display the specific data from (Table 1 data page) based on two selections (drop down selected (Y9) and cell clicked (Y11-Y30).

Can this be done? If so, what type of Vlookup can I use?



Please help. I'm over due with this report so any information or alternative solution you could provide would greatly help.
 

Attachments

Hello! Thank you for your prompt response. You don't know how much I appreciate it!

I opened the spreadsheet and I can see that now, with your change, it prefills the percentage based on the month selected in Y9 and branch selected from range Y11-Y30 which is great, that is exactly what I wanted.

But I have one problem now. Now my list in column A isn't working. It appears not the list in column Y is tied somehow to the list in column A. I had this same type of feature in A9-A28, you could click on a branch from that list and the graph in orange would prefill with the numbers for that selection (that data is feeding from a transactions handled table in the cal tab.

Any suggestions and how to make them both work and display their own data based on their own tables? Originally I labeled the list in column A plst branch and the list in column Y plstbranches, I'm not sure if that is correct.
 
You must log in or register to reply here.
Back
Top