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