LinkBack URL
About LinkBacks
KIRAN NAIDU 
Dear One
In below attached file 2 sheets are there one is HYD-SUM and two is NEW RES.
I want in HYD-SUM in Y column branch and class wise str as per NEW RES sheet. kindly resolve the problem.
Dear One
In below attached file 2 sheets are there one is HYD-SUM and two is NEW RES.
I want in HYD-SUM in Y column branch and class wise str as per NEW RES sheet. kindly resolve the problem.
Please add about 10-15 rows of expected results (manually) to your workbook and post again.
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.
Try this in cell Y3 and fill down.Formula:
=VLOOKUP(E3,'NEW RES'!$D$8:$R$15,MATCH(I3,'NEW RES'!$D$7:$R$7,0),FALSE)
Dave
Thank you so much sir
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
You are welcome. Please mark as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks