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
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
cancel that, doesnt work. sorry
Last edited by chris2485; 11-30-2007 at 10:38 AM.
This seems to do the trick. Thers probably a better way though
Chris![]()
Please Login or Register to view this content.
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
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.![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks