The parametr is vendor.i want vendorwise quantity detail of stock item and item code is primary differentiating factor On Jan 7, 2013 9:59 AM, "Lalit Mohan Pandey" <mohan.pande...@gmail.com> wrote:
> Hi Harshad, > > First of all this thread should be comes under you previous thread as you > are asking same thing in both thread > > > https://groups.google.com/forum/#!topic/excel-macros/Y2PNmj1V-ZU%5B1-25-false%5D > > And second what is the parameter to differentiate two same values. > > Regards, > Lalit Mohan > > On Friday, 4 January 2013 21:58:57 UTC+5:30, harshad shukla wrote: >> >> if on using VLOOKUP and for same item code and repeated twice in the >> list,it should generate the corresponding inventory value .In actual only >> the first value is taken repeatedly if the vlookup value is coming twice in >> the list. >> >> On Fri, Jan 4, 2013 at 5:00 PM, Prince <prince...@gmail.com> wrote: >> >>> explain bit more could't understand ur requirment. >>> >>> Regards >>> Prince >>> >>> On Friday, January 4, 2013 4:52:35 PM UTC+5:30, harshad shukla wrote: >>>> >>>> Please find attachd file.if two values of material code is same then >>>> corresponding target inventory value should be displayed.ordinary only one >>>> value is repeated twice. >>>> ---------- Forwarded message ---------- >>>> From: "HARSHAD SHUKLA,D&D,OMAX,LKO" <harshad...@omaxauto.com> >>>> Date: Jan 4, 2013 3:58 PM >>>> Subject: Copy of Inventry control plan.xls >>>> To: <er.harsh...@gmail.com> >>>> >>>> >>>> >>>> >>>> DISCLAIMER: This e-mail including attachment, contains confidential and >>>> privileged information intended for exclusive use ofthe addressee. The >>>> company does not assume liability including inadvertent virus infestation, >>>> arising out of this mail, unless specifically agreed to, with the >>>> recipient.If you are not the intended recipient, please contact the sender >>>> by reply e-mail and delete original and all copies of this message. Any >>>> dissemination, use, reliance on, review, distribution, printing or copying >>>> of this message in whole or in part is unauthorized and strictly >>>> prohibited. >>>> >>>> >>>> -- >>> Join official Facebook page of this forum @ https://www.facebook.com/** >>> discussexcel <https://www.facebook.com/discussexcel> >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To post to this group, send email to excel-...@googlegroups.com. >>> To unsubscribe from this group, send email to excel-macros...@** >>> googlegroups.com. >>> Visit this group at >>> http://groups.google.com/**group/excel-macros?hl=en<http://groups.google.com/group/excel-macros?hl=en> >>> . >>> >>> >>> >> >> -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.