Results 1 to 7 of 7

I need to find a specfic text in a range of cells and return specfic text

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2016
    Location
    Dallas
    MS-Off Ver
    2013
    Posts
    3

    I need to find a specfic text in a range of cells and return specfic text

    I need to find specific text in a range of cells and return the text two columns to the right of the cell that contains that text.
    If any of the cells A1:E6 contain an "a" I need to return the text in column h on the same line that the "a" is in.

    Capture.JPG

    Thanks in advance,
    Richard
    Last edited by ramjdmcmm; 03-15-2016 at 03:03 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. if text is in specific format then file other cells with specfic text
    By Louisa Venter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2016, 02:45 PM
  2. Replies: 2
    Last Post: 09-25-2013, 03:17 AM
  3. Trying to search a range and find a specfic item based on a condition.
    By Cornered99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2013, 05:10 PM
  4. if find blank in specfic ranges then blank the specfic range cells
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2012, 11:19 AM
  5. Highlight rows containing specfic text
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-21-2008, 09:42 AM
  6. [SOLVED] insert picture to a specfic range of cells
    By CORY in forum Excel General
    Replies: 8
    Last Post: 02-03-2006, 01:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1