Results 1 to 7 of 7

Thread: Which method: Vlookup, InStr, Other?

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    What is the VBA comparative native function for VLookup, Select Case or is there not a specific one and Select Case would be the closest one to it?

    What do you mean about a loop w/in a loop?

    I do see your point about replacing a partial vs. a whole word match, how can I rewrite this w/out the InStr? I used InStr in other bits and would like to go back and fix.
    Last edited by YellowLabPro; 07-29-2007 at 07:19 AM.
    my site: www.ecboardco.com
    was built w/ a majority of the assistance from the board members here... thanks VBAX.

    Just because I see something, doesn't mean that what's actually happening is what I see.

    You don't get from 0-90 by standing still!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •