LinkBack URL
About LinkBacks
i want to put values search by names in comm sheet and in output sheet values comes as per date of that person name could anybody help me as I was trying so many days..
i want to put values search by names in comm sheet and in output sheet values comes as per date of that person name could anybody help me as I was trying so many days..
Last edited by AliGW; 01-16-2022 at 06:16 AM. Reason: Title changed - please think more carefully about your thread titles in future!
Administrative Note:
Welcome to the forum.
Windoe=ws 10 is your OS, not your Office version.
Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
NOTE: I have improved your thread title. Please see the forum rules about thread titles and bear in mind in future.
Last edited by AliGW; 01-16-2022 at 06:16 AM.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
One way:
=IFERROR(INDEX(INDEX(Comm!$A$3:$GY$33,,MATCH(OUTPUT!$C3,Comm!$1:$1,0)+MATCH(E$3,Comm!$B$2:$G$2,0)),MATCH($D4,INDEX(Comm!$A$3:$GY$33,,MATCH(OUTPUT!$C3,Comm!$1:$1,0)),0)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks a lot, sir I was trying this for so many days. you were like superman to me.
Your data layout did make it a bit tricky!!
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. As you are new, I will do it for you today: https://chandoo.org/forum/threads/he...oo-much.47434/)
Two rules broken in your first thread here - please read our rules before posting here again. Thanks.
I don't have the time to wait and my boss was angry with me that's why I make posts on both sites. I will not do crosspost in future
You have missed the point: of course you CAN cross post, but you MUST declare it on each site where you do it by adding links.
Your boss and his attitude to you and whether or not you are pressed for time have no bearing whatsoever on this and other forums' rules - sorry.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks