Consulting

Results 1 to 7 of 7

Thread: search for mulitiple text strings, return value

  1. 09-29-2008, 08:25 AM #1
    pdeshazier
    pdeshazier is offline
    VBAX Contributor pdeshazier's Avatar
    Joined
    May 2005
    Posts
    103
    Location

    search for mulitiple text strings, return value

    i've attached a spreadsheet in which column H could contain various text strings and for each possible string, i want a value returned in column O. I'm using a formula combining IF, ISNUMBER, SEARCH as you can see in column O but it's getting too long/complicated b/c of the number of possible search strings. is there a way i can simplify this? thanks in advance for any help
    Pam White
    Highpoint Health System
    pam.white@lpnt.net
    Reply With Quote Reply With Quote
  2. 09-29-2008, 09:39 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    .
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 09-29-2008, 10:58 AM #3
    pdeshazier
    pdeshazier is offline
    VBAX Contributor pdeshazier's Avatar
    Joined
    May 2005
    Posts
    103
    Location
    i've posted several in the past, so why is my post count 0?? what do i need to do so the attachment can be viewed?
    Pam White
    Highpoint Health System
    pam.white@lpnt.net
    Reply With Quote Reply With Quote
  4. 09-29-2008, 11:59 AM #4
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Sorry, no idea. I see your post count as 66. Perhaps one of the admins will jump in.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  5. 09-30-2008, 01:27 PM #5
    Aussiebear
    Aussiebear is offline
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,060
    Location
    Attached is Pam's file
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link
    Reply With Quote Reply With Quote
  6. 10-01-2008, 06:24 AM #6
    pdeshazier
    pdeshazier is offline
    VBAX Contributor pdeshazier's Avatar
    Joined
    May 2005
    Posts
    103
    Location
    thanks aussie

    Quote Originally Posted by Aussiebear
    Attached is Pam's file
    Pam White
    Highpoint Health System
    pam.white@lpnt.net
    Reply With Quote Reply With Quote
  7. 10-01-2008, 06:29 AM #7
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    I don't see any difference from this and the original file. Did you look at the file I posted?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules