scooby_simon Posted September 13, 2007 Report Share Posted September 13, 2007 I want to search a excel column for data items in a list: So something like this might work, but it does not: =MID(I67,SEARCH(list-of-error-messages,I67,1),4) I have a list of support calls, and some of these contain error messages; I would like to check the text (in column I) for error messages; If we are feeling really clever, I would also like to scan the file (col I) tocreate the lst of error messages; error messages are of the form Alpha followed by 3 numerics. Ideas ? Quote Link to comment Share on other sites More sharing options...
Froggy Posted September 13, 2007 Report Share Posted September 13, 2007 Use LOOKUP or HLOOKUP I think will achieve what you want. Sorry not used them for years so can't be more help. Quote Link to comment Share on other sites More sharing options...
Mook Posted September 13, 2007 Report Share Posted September 13, 2007 Try auto-filter on the list of calls, then sort alphabetically? Quote Link to comment Share on other sites More sharing options...
scooby_simon Posted September 13, 2007 Author Report Share Posted September 13, 2007 No good; the text is free format; what I want to do is take the text, extract the common error messages and build project(s) to fix the more common ones. Quote Link to comment Share on other sites More sharing options...
Mac Posted September 14, 2007 Report Share Posted September 14, 2007 Seperate the two - search by error, and then lookup on the outcome of the search. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.