Hello Vabz Thanks for Logic based on your criterion formula But Can you explain it.What is minus Row 5 & Row 10 logic.I cant Understand it.In my data there are 9 column & 13 Row but it is different for different name as per. I will use it but not work I use it & minus Row 8 in formula But formula show NA. Regards Amar
On Wed, Sep 26, 2012 at 12:12 PM, Vabz <v...@vabs.in> wrote: > Hi > > Sorry for Late reply, I have defined some logic based on your crieterion, > see it works or not.. > > Rgds//vabs > > > On Tuesday, September 25, 2012 5:43:07 PM UTC+5:30, amar takale wrote: > >> Need help. >> >> On Tue, Sep 25, 2012 at 2:38 PM, amar takale <amart...@gmail.com> wrote: >> >>> Hi Vabz >>> I will try it but how to range criteria.Bcos after giving formula I used >>> data validation for name.If I click Name Then all other criteria show inone >>> shot. >>> >>> >>> On Tue, Sep 25, 2012 at 12:00 PM, Vabz <v...@vabs.in> wrote: >>> >>>> Dear Amar >>>> >>>> You can use sumproduct for your query >>>> >>>> Rgds >>>> >>>> >>>> On Monday, September 24, 2012 7:01:25 PM UTC+5:30, amar takale wrote: >>>> >>>>> Pls find attached below file >>>>> >>>>> See Attached file. >>>>> >>>>> On Mon, Sep 24, 2012 at 6:43 PM, amar takale <amart...@gmail.com>wrote: >>>>> >>>>>> Dear Group Members, >>>>>> >>>>>> >>>>>> >>>>>> Please Solution Need! >>>>>> >>>>>> >>>>>> >>>>>> I need to apply Vlookup+Match formula to get value in sheet1 (C5 to >>>>>> F5) cell But it show same Output below. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Sheet1 (C5 to F5) cell& Below cell is the result cell where I want >>>>>> to use the formula to get the output from sheet2. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Best Regards, >>>>>> >>>>>> Amar >>>>>> >>>>>> -- >>>>>> Join official facebook page of this forum @ https://www.facebook.com/ >>>>>> **discu**ssexcel <https://www.facebook.com/discussexcel> >>>>>> >>>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>>> >>>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>>> in signatures are prohibited. >>>>>> >>>>>> 6) Jobs posting is not allowed. >>>>>> >>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >>>>>> allowed. >>>>>> >>>>>> NOTE : Don't ever post personal or 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. >>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>> Join official facebook page of this forum @ https://www.facebook.com/** >>>> discussexcel <https://www.facebook.com/discussexcel> >>>> >>>> FORUM RULES (1120+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> 6) Jobs posting is not allowed. >>>> >>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>>> >>>> NOTE : Don't ever post personal or 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. >>>> >>>> >>>> >>> >>> >> -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
