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
