I would like to find a way to simplify some work in classifying post-secondary institutions by one of four types. I have created a sample worksheet with the four ranges I am using, but cannot figure out the equation for the desired output which I have included.
I think that I was able to upload the file, but cannot see it on this page.
One way, rearranging your keywords a bit:
=IFERROR(LOOKUP(1000,(SEARCH('Test range'!$B$7:$B$23,D5)),'Test range'!$C$7:$C$23),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Fantastic Glen
Works like a charm. I don't know why I didn"t think of just putting it in one range - much simpler.
I fooled around with fancy ideas of keeping the apart... and gave up!!
Anyhow, you're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks