Formula result details - Hyperlink or any other idea

With no attachment it is hard, but the easiest way to drill is to use a pivot table as clicking on a value will show you the underlying data, or even quick explore, which I do not have access to in my version of excel
https://support.office.com/en-gb/art...7-629bf6f7ee0b

I have attached example, hope is good. Unfortunately i cant use pivot, since i have Business plan, and i need to have visible variance like on sheet for every month through year

You have attached the sheet, but not what it references. So you wish us to show information that is on a sheet we cant see!

Ahhhh Sorry for that, i am attaching, hop its working now

Hi Glenn.

Not sure did i understand you...

All Transaction sheet contains a lot of accounts and data for 10 months ( Should be for whole year )
Shee1 should pull all data based on Project from drop down..

I just need, in this case to be able when select 35 AED ( Actual figure in Jan-19 for cost account#1) to see all details for that figure ( All bookings under this account), since this is the summary pf all bookings under this account, this project and this month ( Cost Account #1, Project #2, Jan-19)

In case you are asking me where details to be shown, would be better if separated sheet

Thanks

I am not sure will Pivot work, since we have Actual - Plan = Variance..

Thank you

Hi Glenn.

Hm, this is not really what i need. It would be ideally that look like pivot table, and when i select value in tab " Sheet1" ( in this case 103 AED) i see details of it, but only for this value.
Do you have any other idea of doing it ? I was thinking inserting Business plan figures in " All Transaction" sheet and then getting pivot out of it, but again, i need to be able to see the variances for every month through the year ?

Thank you