+ Reply to Thread
Results 1 to 3 of 3

Search formula referencing range of keywords

  1. #1
    Registered User
    Join Date
    12-12-2005
    Location
    USA
    MS-Off Ver
    2007 with XP Pro
    Posts
    25

    Search formula referencing range of keywords

    I'll try to describe all the relevant information...

    Column A - contains comment fields, randomly containing keyword(s)
    Column B - contains the unknown search formula, yet to be determined
    RangeXYZ - contains a list of multiple keywords

    I wants the formula in B2 to search the comment field A2 using the entire list of keywords found in RangeXYZ. The general assumption can be made that a comment field should only contain one keyword. I'd like A2 to result in a blank or "NA#" if nothing was found... or the keyword, if any keyword was found.

    For example:
    A2 = "The customer was happy about their widget."
    B2 = Unknown search formula, resulting in "widget"
    RangeXYZ contains = widget, newspaper, sports car, computer, calculator

    I hope that I provided enough information...

    Thanks for any help or insight...

  2. #2
    Forum Contributor
    Join Date
    08-21-2006
    Location
    Ossett, West Yorkshire
    MS-Off Ver
    2003
    Posts
    150

    Smile

    Hi,
    Vlookup will do this for you in B2 enter
    =Vlookup(A2,$X$1:$X$5,1,False) and drag formula down the col
    Assuming your list of keywords are in col X
    Regards Howard

  3. #3
    Registered User
    Join Date
    12-12-2005
    Location
    USA
    MS-Off Ver
    2007 with XP Pro
    Posts
    25
    Quote Originally Posted by Gearcutter
    Hi,
    Vlookup will do this for you in B2 enter
    =Vlookup(A2,$X$1:$X$5,1,False) and drag formula down the col
    Assuming your list of keywords are in col X
    Regards Howard
    Unfortunately, I was unable to get that formula to work...

+ Reply to Thread

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