Hi,
Pls find enclosed in attachment.I have a worksheet name "result"in K column I could not pull out the desired result.Here,I have mentioned the expected result manually in K column.But in J it is able to pull out using vlookup & substitute but not in K column .The match is done between worksheet pt.In my actual worksheet "pt"is infact a pivot table data.
However,any function like sumproduct,etc can be used to get the desired result.
Thanx in advance.
Last edited by paradise2sr; 09-13-2018 at 08:11 AM.
Your output looks wrong to me.
There are not multiple entries for 970237
There are multiple entries for 970856.
in L22
=VLOOKUP(J22,pt!B1:C1000,2,0)
will return a single value
Not sure how you're gonna deal with multiple entries
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
No, matching should be done with A22 and not with J22 of result worksheet with that of A column of pt worksheet and just pull data of C column of pt worksheet.Also K23 data in result worksheet can be ignored as it results in multiple entries.I hope it would further ease to all.
The problem because of length of character in both sheets.
if you enter function =len(A22) in result sheet & =len(A5) in pt sheet you will get result as 36 & 35.
Excel count blank space also.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
I have found this
Index(pt!c5:c8,match(substitute(result!A22," ",""), substitute (A5:a8," ",""),0)) with CSE
Now to get further desired result
Since A7 data in pt worksheet is blank,then,K23 result in result worksheet should show error,or user-defined text as match found of A23 in result worksheet to that of A6 below data i.e A7 is blank in pt worksheet.
How this can be now further done or extended taking into consideration that if corresponding matching data below is blank in index,match, substitute formula or any best of it.
Last edited by paradise2sr; 09-13-2018 at 02:41 PM.
Still waiting,if possible by VBA then also pls let me know.
Now I have posted at also link https://chandoo.org/forum/threads/wh...working.39740/
Last edited by paradise2sr; 09-14-2018 at 08:08 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks