Hi Amar, Just Paste the following formula in I6 Cell and Drag up to data I26.
=IF(ISERROR( IF(ISERROR( VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0))/K6),"",IF(ISERROR( VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0)),"NA",VLOOKUP(C6,Sheet2!$B$7:$F$25,5,0))/K6) Regards Prince On Friday, January 4, 2013 10:26:28 AM UTC+5:30, amar takale wrote: > > Hi Prince, > I attached sheet Vlookup sheet for small Qtry changes,Pls see it for > solution. > > Regards > Amar > > On Thu, Jan 3, 2013 at 8:44 PM, Prince <prince...@gmail.com > <javascript:>>wrote: > >> Ignore the last one >> PFA >> >> >> On Thursday, January 3, 2013 6:28:42 PM UTC+5:30, harshad shukla wrote: >> >>> 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 <prince...@gmail.com> 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 <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-...@googlegroups.com<javascript:> >> . >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com <javascript:>. >> 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.
