+ Reply to Thread
Results 1 to 4 of 4

Search keyword in diff sheet and populate new column

  1. #1
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    Search keyword in diff sheet and populate new column

    Hello Everyone!

    In sheet1, I want to search 'StudentName' working in different company (sheet2 contain the list) and then add one column 'Sector' at the end to populate Student working in respective company in another sheet 'Data'.

    My output should be like in sheet 'Data'

    Advance thanks for your help
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Search keyword in diff sheet and populate new column

    Please find the attached sheet to see if this is what you want.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    10-02-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    165

    Re: Search keyword in diff sheet and populate new column

    Its working. Thanks!!!

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Search keyword in diff sheet and populate new column

    Glad to know that. If you think the solution I provided was helpful to you, you may click on * (star) to Add Reputation, which is a small favor to those who have put their time and efforts to help you in this forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 03-18-2014, 11:16 AM
  2. Replies: 0
    Last Post: 07-30-2013, 07:42 PM
  3. [SOLVED] Populate Listbox from 2 columns based on search keyword from text box
    By sivakumar123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2012, 12:22 AM
  4. Replies: 2
    Last Post: 07-13-2012, 04:02 AM
  5. Replies: 1
    Last Post: 12-27-2010, 08:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1