hai, sorry like this, it is not useful for me(for my internal office work). for my work i want like this only, Is their any possibility like this plz find the solution, and one more thing is that the batches are like this are nearly 20000,so their is no possiblity to use the pivot table, i check like this also.
Plz give the solution what i have asked format. it will usefull me. Thanks and Regards, Muralidhar E. On Thu, Nov 11, 2010 at 12:47 PM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > Hello Muralidhar, > > Instead of Vlookup you can use Pivot table it depicts good results. > > Please find Attached is the solved sheet.. > > Let me know if you are looking for the same or anything else. > > Thanks, > Raj > > On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e <emuralidha...@gmail.com>wrote: > >> Dear all group members, >> >> I want to get the L T no, by using vlookup formula, by repeated batches. >> file was attached plz suggest me how to do this by using lookup formula for >> repeated.Iam using MS-Office 2007. >> >> Warm Regards, >> >> Muralidhar E. >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
