Hi Imran, I have followed the following logic:
In Column G, i have entered a IF Statement, which will seek for Text in columns H to M, as soon as it finds and text in any of the first columns, that will be imitated in Column G Please see the attached file Thanks Harpreet Gujral On Mar 10, 12:52 pm, Imran khan <ikha...@gmail.com> wrote: > Hi All, > > I need help in the attached file. Actually Column H, I, J, K, L, & M is > vendor name which i dont want to show. In row 6, 7, 8...., there will be > only one code which i want to come automatically in Column G (Coding). > Please help. > > Thanks, > > Imran Khan > Project Control Engineer > KBR - Kellog Brown & Root > Saudi Kayan Olefins Project > Al-Jubail (KSA) - 31952 > Mobile: +966-552158721 > Email: imran.kh...@kbr.com > > Coding List.xls > 41KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 6,800 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
Coding+List(1).xls
Description: MS-Excel spreadsheet
