VBA script to use exact match on just a predefined list and ignore other context.

Hi

So I have a script in VBA (see below), which is able to find different types of soil from a defined table in cells with text (exact match) in a column and paste it elsewhere. For example, in Sheet 2 i have a long list of soil types such as:
silt, clay, silty clay, gravelly clay etc...

One of the issues I had was that was that the script would pickup on both silt and silty clay for example if I searched for silty clay as it contains "silt". I got some help to change the script to exact match so if I present silty clay, I only get "silty clay" returned. However, this tweak in the scrip (exact match) has also made the script not be able to idetify cells with additional text in it. Lets say I present this in a cell "slighty silty clay", as it is nolonger an exact match, the script does not recognize it. My question is then, how do I keep the script searching for exact matches BASED on the long list of soil types such as: silt, clay, silty clay, gravelly clay etc... )as previously mentioned and ignore everything else?

Please Login or Register  to view this content.

Best regards,

Marius

Originally Posted by AlphaFrog

This will do a whole word match but still be a partial match within the text. So Silt will not match Silty, but Silty Clay will match Slightly Silty Clay.

Please Login or Register  to view this content.

Okay cheers, where would I implement it into the script? Sorry I'm a complete novice :P

Thanks for quick reply.

When I made your adjustment it listed every single cell with the name "clay" in it (e.g silty clay, gravelly clay, sandy clay etc..) instead of just just returning "clay"