Compare Varying String Against Another Row By Row and Paste

[TBrooker]

Ok I honestly don't know where to start with this one.

I have a worksheet where in column S I have GOV### or PRV###, where ### are numbers going 001-100.

For each row I want to check if in column V the GOV### statement or PRV### statement exists anywhere in the text and then paste next to it that text plus what is 5 "letters" to the next of it.

I can't think of an easy way to explain this so I've included an excel spreadsheet showing what I start with and then what I want to end with.

Also so I'm not just taking somebody's code and running with it without understanding it or being able to get at least someway to writing it myself can anyone recommend a guide/book or whatever which would teach me how to do something like this? My knowledge doesn't extend this far from what I've learnt elsewhere.

PRV Sample Workbook.xlsx

Thanks for any help,

[Richard Buttrey]

Hi,

One way in W2 copied down

Please Login or Register  to view this content.

If you had Excel 2007 or later that could be simplified further.