Hi all,
I am trying to combine 3 formula into 1.
indirect
vlookup
calculation (minus and divide)
hlookup from the dropdown menu ( Q15 )
then
indirect to Q17 (January tab )
then
Calculate
(AN4-AN3-AN5)/(AN4-AN5)
Hi all,
I am trying to combine 3 formula into 1.
indirect
vlookup
calculation (minus and divide)
hlookup from the dropdown menu ( Q15 )
then
indirect to Q17 (January tab )
then
Calculate
(AN4-AN3-AN5)/(AN4-AN5)
There is no VLOOKUP formula in your sample sheet, nor is there any working drop-down. How are we expected to work our a formula for you without two of the three elements included???
Also you need to tell us what your expected result is (value).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I have unmerged the cells, to help with locating the drop down menu (Q15)
I have added the expected results in column X & Y.
for example.
from the drop down menu, if I select
Acton, then it will calculate 90% in January Tab.
Ealing, then it will calculate 50% in January Tab
Put into R17:
Formula:Please Login or Register to view this content.
then drag it down for rest of months.
For unexisted months tab's it gives you 0% as there is no data.
Check attached file.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
thank you for your help, but my results are showing 0%. i am using excel 2016, it could this reason?
You are showing MS365 in your profile, so that's what answers will have been tailored to!
hi, i have updated my profile. work i have access to 2016, personal 365 thats where to confusion has happened.
Try attached file. Some tweak added. Should works.
Hi Kokesek. thank you for you help. your solution is amazing. However what you have created it too advance for me. i looked at name manager and i do understand what has been created.
Happy to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks