Searching a range

I'm trying to lookup one value in a list. For instance, if value "A" appears in column B then this else that. Problem is, I don't know how to define the range, or the code to search a range. Really just vlookup VBA style. Any help? Thanks
Paul

This seems to do the trick. Thers probably a better way though

Please Login or Register  to view this content.

Chris

It does, but I need to write it into a macro, not as a function.

Anyone else help with the code necessary to make this work?
Thanks
Paul

Please Login or Register  to view this content.

Here's a different approach

Please Login or Register  to view this content.

Note that the Match method is never case sensitive, but the .Find method can be made case sensitive.