Vlookup alternative

I need perform a function similar to a Vlookup, however the vlookup is ineffcient because it is looking through 32,000 values. I wanted to write some macro that will perform a "find" from a short list against the large 32,000+ list. If the value is found, a specific value (i.e "x") is put in the adjacent cell. Once the value is matched the macro goes to the next value in the list (since there can only be one occurence of each there is no point in going throough the remainder of the list). Any input welcome

Originally Posted by jchambers00

I need perform a function similar to a Vlookup, however the vlookup is ineffcient because it is looking through 32,000 values. I wanted to write some macro that will perform a "find" from a short list against the large 32,000+ list. If the value is found, a specific value (i.e "x") is put in the adjacent cell. Once the value is matched the macro goes to the next value in the list (since there can only be one occurence of each there is no point in going throough the remainder of the list). Any input welcome

I think Vlookup is very efficient. It does not scan through all 32000 values every time, as you said . Moment it finds a match it abandons the search and does not go through the rest of values. It will only scan all the 32000 values if it does not find a match or finds a match at the bottom of the table array.

A V Veerkar