Dear Gopi, Please find the attached solution as per your requirements.
Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, Feb 1, 2010 at 12:42 PM, krishnan Gopi <excelg...@gmail.com> wrote: > Dear Dilip, > > I am looking at a formula wherein if we have a following code, then > automatically the next column should have the Status. Basically i am looking > at a if condition > > To be more precise, i have the following code, if following codes are > entered then i should have the corresponding status against them in the next > column > eg: if i have a code say "300987" in column d I need to get a > particular value say 23 in column "ab". These values (23) are predefined > based on the codes. > > Hope this will help. > > Regard, > Gopi Krishnan > +91- 9886118108 > > > On Sun, Jan 31, 2010 at 11:31 PM, Dilip Pandey <dilipan...@gmail.com>wrote: > >> Dear Gopi, >> >> I am little confused per below points:- >> >> 1) Do you want if a user enters the data which is there in Column B, in >> any of their respective locations <at present>, then to print the keywords >> as given by you in column C. For example, if a user enters any of the >> following in Cell B3 to B7, then print "Pending" in C. 49004 49005 >> 49006 49007 49008 >> >> 2) Do you want the user to enter these numbes some where else and then >> print the keywords in C. >> >> Please elaborate little more. Thanks. >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B Com(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> >> On 1/29/10, krishnan Gopi <excelg...@gmail.com> wrote: >>> >>> Hello All, >>> >>> Please find attached the excel i have explained the issue. >>> >>> Thanks a lot in advance. >>> >>> Regards >>> Gopi Krishnan >>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 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 >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,700 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 >>> >>> >> >> > -- 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 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
If Condition - By DILipandey.xls
Description: MS-Excel spreadsheet
