+ Reply to Thread
Results 1 to 1 of 1

need to search multiple cells for a value then display cell in column next to it

  1. #1
    Registered User
    Join Date
    02-19-2014
    Location
    Frederick, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1

    need to search multiple cells for a value then display cell in column next to it

    Hi- Im fairly new to using complex formulas in Excel, so I hope I can define my issue clearly:

    I have a report that puts multiple tasks into column B (Monitoring, Project Management) that are associated with the correspondng region (in column A) assigned to do the task (US, EU, AP). I am trying to search this group for a given task (lets say monitoring) that may appear multiple times in column B and report on another sheet which groups go with that task (which there may be multiple). Problem is that the tasks may be listed by themselves (Monitoring) or with several tasks in the same cell (Monitoring; Project Management) and I need to only pull the region if they are assigned that specific task:


    Column A
    A1 SAN
    A2 SYR
    A3 AMER
    A4 US
    A5 EU


    Column B
    B1 CPU
    B2 Bio; Project Management
    B3 Imaging
    B4 Monitoring
    B5 Biostatistics; CSR Development; Data Management; Medical Affairs; Monitoring; Pharmacokinetics; Project Management; Protocol Development; Protocol Synopsis Development; TFL Development

    how can I find and display in cell D that US and EU have Monitoring:

    Sheet 2
    Column C
    C10 Monitoring

    Column D
    D10 US; EU

    ?????

    Many thanks in advance

    Paul
    Last edited by pdub.wash; 02-19-2014 at 01:35 PM. Reason: spacing

+ 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. [SOLVED] Search for phone number list in multiple cells and display an alert.
    By venkatakrishna in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-03-2014, 11:18 AM
  2. [SOLVED] Display multiple search results by column
    By Declan.Ryan in forum Excel General
    Replies: 19
    Last Post: 11-09-2012, 08:51 AM
  3. Search column for non-empty cell and display results?
    By Kiltman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2007, 07:34 PM
  4. Replies: 9
    Last Post: 07-04-2006, 06:50 PM

Tags for this Thread

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