Hi Intellect,
Good day,
Need your help to fetch the data based on the drop down list, it's dynamic value. seeking your advice to fix this issue.
I have attached the file for your reference.
Thanks in advance!!!!....
Regards
Rajuganapathy
Hi Intellect,
Good day,
Need your help to fetch the data based on the drop down list, it's dynamic value. seeking your advice to fix this issue.
I have attached the file for your reference.
Thanks in advance!!!!....
Regards
Rajuganapathy
You have 2 sets of drop downs for "AOP Goal Casc" and "YTD". Which ones do you wan to use? Also, in which cell do you want the result to be displayed?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hi Mumps1,
Thank you very much for your reply, apologies for that am not explained my question very clearly in the above statement. i have attached the screen shot for your reference.
based on the reference with YTD and value we need to get the data from the left side defined table. hope this helps. appreciate for your quick response. Thank you
Regards
Raju
Drop down.PNG
OK, that's fine but you haven't said where you want to place the data from the left side defined table. In which cells do you want to return the "Reference" and "Loading" values?
Cell "L9" is Reference value and the Cell "L10" is Leading value
Hi Mumps1,
Hope i have answer your question!!.....
Regards
Raju
Be patient!
I am sorry you are having trouble with commercial services, which is working for other members. That will be looked into, but it does not mean that you will get preferential treatment here on the main forums - sorry.
You now say you want a formula, but posted in the VBA section - do you want me to move the thread for you?
The help you get here is given freely and you already have interest in your issue: I am sure you will get some more help today.
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.
Hi AliGW,
Unfortunately i have posted this one in to VBA section, i needed only excel formula's kindly move in to this.
Regards
Raju
Thread moved. I hope you will get some help, but you must be patient.
Thank you AliGW
Any help please
Apart from anything else, it's a Saturday!!! Most people around the globe will not be working. Here in the UK it's not even midday, in Australia it's the evening and in the US they are only just beginning to get up. For goodness' sake, exercise a little bit of patience! I have already apologised that the CS section is not working for you, but even there, help would not be instant. If it really is that urgent, you ought to seek out an agency and pay them to sort this out for you, but even agencies don't work on Saturdays. In short, you are displaying impatience with a group of well-meaning volunteers, and this is not going to do you any favours.
Those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
You may bump your thread again in 24 hours' time if you have still had no help.
Last edited by AliGW; 10-27-2018 at 05:57 AM.
I'm not sure if it can be done with formulas. It may be possible but using formulas is not my strength.
The attached file will do what you want using formulas.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks