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
Bob Phillips
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?
Bob Phillips
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
Bob Phillips
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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.