Results 1 to 5 of 5

Search for Text within Text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-02-2008
    Location
    Utah
    Posts
    171

    Search for Text within Text

    Hi Fellow Excel'rs,

    I am looking for a formula to search within a cell for text that matches the text I have in a list. If it matches, then I want it to return the value in my list offset by to columns. In the attached spreadsheet, If cell B4 contains text that matches any of the values in column K, then return the country in column M. I then want to drag this formula down column C.

    Thanks so much!
    John
    Attached Files Attached Files
    Last edited by John Bates; 09-03-2009 at 05:44 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

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