Dear Dilipji, Thank you very much, It is working, but one problem It showing error when nothing is entered, I have tried to insert isserror formula, but not able insert it. if possible please revise my file. again thank you very much for your kind help
On Sat, Jul 24, 2010 at 9:24 AM, Dilip Pandey <dilipan...@gmail.com> wrote: > Thanks Rahul, > > No doubt, "concatenate" and "&" will do the task but for that we need > to have a column on both d locations n we also need to check if this > is feasible. > But anyways both the ways are ok n there are other ways as well :) > > thx, > DILIPandey > > On 7/24/10, Rahul Gandhi. <myname.ra...@gmail.com> wrote: > > I Think in particular this scenerio we have one more function of > > "Concatenate" or "&". > > > > that also helps us to do the same, at the other hand this formula is > > also very suitable for so many conditions.. > > > > Thanks again sir. > > > > > > > > On Jul 23, 6:33 pm, Dilip Pandey <dilipan...@gmail.com> wrote: > >> Hi Hari, > >> > >> I have achieved the desired result using array functionality in Vlookup > >> function. > >> See the attached file and let me know if this helps. > >> > >> -- > >> Thanks & Regards, > >> > >> DILIP KUMAR PANDEY > >> MBA-HR,B.Com(Hons),BCA > >> Mobile: +91 9810929744 > >> dilipan...@gmail.com > >> dilipan...@yahoo.com > >> New Delhi - 62, India > >> > >> On Fri, Jul 23, 2010 at 4:38 PM, HARI NAIR <hari.shrin...@gmail.com> > >> wrote: > >> > I want to fill the basic rate column automatically from the rate > >> > column(Please refer the attached file, which considers all three > columns > >> > factors, like, PO NO, Thickness. Width, & Quality. Not a single > column > >> > factor. Please Help, Any how, thanks to prajapatiji for sending me > the > >> > solution which I earlier sent, in which only single colunm factor is > >> > looking > >> > (i.e. Quality) > >> > >> > Regards, > >> > >> > Hari > >> > >> > -- > >> > >> > > ---------------------------------------------------------------------------------- > >> > 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 athttp://www.excel-macros.blogspot.com > >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > >> > >> > To post to this group, send email to excel-macros@googlegroups.com > >> > >> > <><><><><><><><><><><><><><><><><><><><><><> > >> > HELP US GROW !! > >> > >> > We reach over 7000 subscribers worldwide and receive many nice notes > >> > about > >> > the learning and support from the group.Let friends and co-workers > know > >> > they > >> > can subscribe to group at > >> >http://groups.google.com/group/excel-macros/subscribe > >> > >> > >> > >> DATA - Vlookup with multiple criteria - by DILIpandey.xls > >> 91KViewDownload > > > > -- > > > ---------------------------------------------------------------------------------- > > 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 > > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > > We reach over 7000 subscribers worldwide and receive many nice notes > about > > the learning and support from the group.Let friends and co-workers know > they > > can subscribe to group at > > http://groups.google.com/group/excel-macros/subscribe > > > > -- > Sent from my mobile device > > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
