Help Please!!

[Veronica Garay]

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.

 

[Somendra Misra]

Hi,

As per your description, there will be one cell that will be as a result, see the file Sheet Dash, cell Z11 has formula. Well your selection was not working at my end, so I did some modification in the code.

Regards,

 

[Veronica Garay]

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.

 

[Somendra Misra]

See the file.

Regards,

 

[Veronica Garay]

Thank you, Thank you, Thank you! It works! You're expertise is greatly appreciated!