Using Search, Index, Lookups, Etc.

**NBVC** · 09-19-2011, 05:10 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

**JasonBarnes** · 09-20-2011, 11:21 AM

I noticed the formula seems to split the text between spaces when searching. Where if you are searching WALMART, it wouldn't pick up TO:WALMART.

I assume this is because its assigning a numerical value to each string delimited by the spaces. Is there any direction you can point me in or help me with that might allow me to search within strings where I would find the match above?

**NBVC** · 09-20-2011, 09:47 PM

I had added that feature specifically to avoid "false" positives., like if you want to look for the word "son", you wouldn't necessarily want it to pick up Johnson...

To remove the feature change formula to:

=IF(X2="","",LOOKUP(9.9999999E+307,SEARCH(IF(INDEX(MyRange,0,2)<>"",INDEX(MyRange,0,2)),X2),INDEX(MyRange,0,4)))

**JasonBarnes** · 09-22-2011, 10:15 AM

I guess that goes back to your quote, "Where there is a will there are many ways"

We also contemplated maybe looping a find & replace and putting the necessary space or delimiter around key pieces before doing the lookup. Only time will tell what ends up being better. Thanks again.