+ Reply to Thread
Results 1 to 2 of 2

return multiple text strings from other worksheet

  1. 03-07-2014, 12:26 PM #1
    Hurseys
    Hurseys is offline
    Registered User
    Join Date
    03-07-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    1

    return multiple text strings from other worksheet

    Hi there

    Can anyone help with the following. I need a formula or array to perform the following in Excel 2010:
    I have 2 worksheets "Master Report" and "Free text comments". The master report will be shaed with individuals but the Free Text comments worksheet will not.

    sample feedback report.xlsx

    In cells D2 downwards on the "Master Report" I want to show the individual feedback comments from the "Free Text comments" worksheet that have been made by other people for the individual named in cell A2 on the "Master Report" worksheet. So on James' master report it would show the 8 individual comments listed for him on the Free text comments" worksheet.

    I have searched the internet and tried various combos of lookups, IFs, index and match but have not come across the right formula yet. Can it be done?
    Thanks
    Reply With QuoteRegister To Reply
  2. 03-07-2014, 12:35 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: return multiple text strings from other worksheet

    Please see attached file with formula.
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    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. Formula to find and return text string within a cell full of text strings
    By LightingPop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 11:45 PM
  2. excel formula to search Multiple strings in several columns and return strings
    By krratna123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-13-2013, 11:20 AM
  3. excel formula to search Multiple strings in several columns and return strings in a separa
    By krratna123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 08:32 AM
  4. Compare text strings in two columns and return text from adjacent cell
    By mohitroshan in forum Excel General
    Replies: 6
    Last Post: 02-28-2013, 11:27 AM
  5. text within multiple strings, look @ dates in next column, return most recent date
    By amazingg64 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2012, 01:44 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