Hi Umesh, Thanks for your help.
On 1/23/11, Umesh Dev <umesh.d...@gmail.com> wrote: > Hi Vikram, > > I hope this would solve your query. > > Regards > Umesh > > > On Sun, Jan 23, 2011 at 11:33 AM, vikram <vikramahuj...@gmail.com> wrote: > >> Hi, >> >> >> >> I need regarding enclosed excel sheet for Duplicate audit for vendors. >> >> >> >> As of now we need to identify different type of invoice as per first three >> numbers of vendors. >> >> >> >> For ex: >> >> >> >> *Code* >> >> *Category* >> >> 901 >> >> Edible Material >> >> 902 >> >> Packaging Material >> >> 903 >> >> Engineering >> >> 904 >> >> Services >> >> 905 >> >> MEDIA >> >> 906 >> >> Capex >> >> 907 >> >> CFA >> >> 908 >> >> Edible Material >> >> 909 >> >> Packaging Material >> >> 910 >> >> CFA >> >> 912 >> >> INTERCO >> >> 913 >> >> Others >> >> >> >> Steps we are following: >> >> >> >> 1) On first instance we use Left function to get first three numbers >> of vendor number i.e for 7 numbers. >> >> 2) Then we use v look up to get above details on sheet on DAT sheet. >> >> >> >> Kindly provide any function or VBA coding to get this avoiding above step. >> >> >> >> In enclosed sheet Column C contains list of all vendor numbers and on the >> basis of this we need to get first three numbers on Column I and we need >> to >> get categorization on Column j. >> >> >> >> >> >> Regards, >> >> >> >> Vikram Ahuja >> >> 08860553902 >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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/discussexcel >> > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > -- Regards, Vikram Ahuja -- ---------------------------------------------------------------------------------- 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/discussexcel
