PDA

View Full Version : search for mulitiple text strings, return value



pdeshazier
09-29-2008, 08:25 AM
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

xld
09-29-2008, 09:39 AM
.

pdeshazier
09-29-2008, 10:58 AM
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?

xld
09-29-2008, 11:59 AM
Sorry, no idea. I see your post count as 66. Perhaps one of the admins will jump in.

Aussiebear
09-30-2008, 01:27 PM
Attached is Pam's file

pdeshazier
10-01-2008, 06:24 AM
thanks aussie


Attached is Pam's file

xld
10-01-2008, 06:29 AM
I don't see any difference from this and the original file. Did you look at the file I posted?