+ Reply to Thread
Results 1 to 4 of 4

Excel formula needed to find string and then copy details from another cell

Hybrid View

  1. 12-09-2014, 08:43 PM #1
    jopat
    jopat is offline
    Registered User
    Join Date
    12-09-2014
    Location
    australia
    MS-Off Ver
    2010
    Posts
    5

    Excel formula needed to find string and then copy details from another cell

    Hi All,

    I have a spreadsheet with 2 Tabs. I'm wanting a formula to find the user name that appears in the User ID tab in Column A and pull the Full Name from Tab Employee Name and place this into the column B in User ID tab.

    User ID.JPGEmployee Name.JPG

    Hope this makes sense. Thanks for your assistance

    Thanks
    Mal
    Reply With QuoteRegister To Reply
  2. 12-09-2014, 09:08 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Excel formula needed to find string and then copy details from another cell

    Try this...

    =INDEX('Employee Name'!A$1:A$2,MATCH(A2,'Employee Name'!C$1:C$2,0))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 12-09-2014, 10:01 PM #3
    jopat
    jopat is offline
    Registered User
    Join Date
    12-09-2014
    Location
    australia
    MS-Off Ver
    2010
    Posts
    5

    Re: Excel formula needed to find string and then copy details from another cell

    Fantastic Tony! Thank you so much..... Worked perfectly!
    Reply With QuoteRegister To Reply
  4. 12-09-2014, 10:10 PM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Excel formula needed to find string and then copy details from another cell

    You're welcome. Thanks for the feedback!


    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA help needed to find text string, clear cells then add new cell value
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2014, 11:29 AM
  2. [SOLVED] VBA Needed to find number/text within cell string and copy out to new cell
    By Campbell A in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-19-2013, 10:15 AM
  3. Calculations by details -formula/VBA help needed
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-28-2011, 05:54 PM
  4. how to find Certain String in a column, select/Copy the cell till another String
    By excelkeechak in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2009, 10:59 AM
  5. putting a string from one cell in the formula of another -- indirect needed?
    By alfrodull@gmail.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2006, 04:00 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1