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 ? 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. 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? 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. 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now