Results 1 to 6 of 6

If row contains value, return x

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2014
    Posts
    4

    If row contains value, return x

    I'm working with an ancient greek lexicon,
    and I'm trying to get all the parsing to line up.

    I have a table with
    A B C D E
    1 ἀκούω I hear present first person singular
    2 ἀκούεις you hear second person singular present
    3 ἄξω I will lead first person future singular

    I want column F to display "present" if the row contains the word "present", "future" if it contains the word "future" etc

    My problem is rather similar to http://www.excelforum.com/excel-prog...ign-value.html, but I'm trying to search the whole row rather than a single cell.
    Last edited by hypershock; 06-08-2014 at 09:21 PM. Reason: make more clear the diversity of categories

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Double click row to return data to userform for edit then return back to sheet
    By MattRSJ in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-31-2014, 06:05 AM
  2. Replies: 12
    Last Post: 10-10-2013, 10:02 AM
  3. Replies: 4
    Last Post: 03-13-2013, 12:38 PM
  4. Replies: 6
    Last Post: 10-11-2012, 02:39 PM
  5. Search...Return...give info based on the return address
    By deek1004 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-11-2012, 03:36 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