Re: $$Excel-Macros$$ Re: Copy of Inventry control plan.xls
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" 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 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" >>>> Date: Jan 4, 2013 3:58 PM >>>> Subject: Copy of Inventry control plan.xls >>>> To: >>>> >>>> >>>> >>>> >>>> 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 M
Re: $$Excel-Macros$$ Re: Vlookup for two same values
I primarily want inclusion of all values in vlookup. Even if there is repetition of two item codes.corresponding inventory should be displayed.ordinarily only first value is taken. On Jan 7, 2013 9:54 AM, "Lalit Mohan Pandey" wrote: > Hi Harshad, > > Could you please explain how can you defrenciate two same value like for > which value i want data. > > Regards, > Lalit Mohan > > On Friday, 4 January 2013 14:52:15 UTC+5:30, Prince wrote: >> >> Share your workbook. >> >> Regards >> Prince >> >> On Friday, January 4, 2013 2:47:55 PM UTC+5:30, harshad shukla wrote: >>> >>> I was stuck up with a problem.i have to use vlookup .but in case of two >>> same values i want distinct values as answer.i.e. if table has two common >>> values .the vlookup should give values as separately. >>> >> -- > 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.
Re: $$Excel-Macros$$ Vlookup for two same values
THANX ..ALTHOUGH THE FILE IS QUITE HELPFUL...BUT IT IS LIMITED FOR EDITING...supposedly i change value for Veg dish...the same is not incorporated in the vlookup. I am also not able to add more items in the list...But thanx a lot for this too.Hope better solution comes next. Harshad On Sat, Jan 5, 2013 at 11:43 AM, ravinder negi wrote: > Here is the anwser, I have attached a file with solution. Please reply if > you want this? > > --- On *Fri, 1/4/13, harshad shukla * wrote: > > > From: harshad shukla > Subject: $$Excel-Macros$$ Vlookup for two same values > To: excel-macros@googlegroups.com > Date: Friday, January 4, 2013, 2:47 PM > > > I was stuck up with a problem.i have to use vlookup .but in case of two > same values i want distinct values as answer.i.e. if table has two common > values .the vlookup should give values as separately. > > -- > 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. > > > -- 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.
Re: $$Excel-Macros$$ Re: Copy of Inventry control plan.xls
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 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" >> Date: Jan 4, 2013 3:58 PM >> Subject: Copy of Inventry control plan.xls >> To: >> >> >> >> >> 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 > > 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.
$$Excel-Macros$$ Vlookup for two same values
I was stuck up with a problem.i have to use vlookup .but in case of two same values i want distinct values as answer.i.e. if table has two common values .the vlookup should give values as separately. -- 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.
Re: $$Excel-Macros$$ Re: How to use vlookup on two parameters simultaneously
dear Sir, please find attached file. In this I have to collect the value of supplier based on item code. For any single item code there can be two or more vendors.I want to get the qty. supplied by each by using VLOOKUP.For any further clarification you can give a miss call on my number mentioned below. regards Harshad Shukla 08765181907 On Thu, Jan 3, 2013 at 4:25 PM, Prince wrote: > Can you please share ur wbk or can explain the senario through an example. > > Regards > Prince > > On Thursday, January 3, 2013 4:09:23 PM UTC+5:30, harshad shukla wrote: >> >> Dear all. >> I was stuck up while using vlookup on two parameters.please help. >> Urgent requirement. >> Harshad Shukla >> > -- > 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. Copy_of_Worksheet_01_01_2013.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ How to use vlookup on two parameters simultaneously
Dear all. I was stuck up while using vlookup on two parameters.please help. Urgent requirement. Harshad Shukla -- 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.
