A hash is usually done via CHECKSUM function. So, K=CHECKSUM("merringold") R=HASH[K] What I usually do, however, is just sort the array, and use binary search. OTOH, assuming all the keys fit in a string, you can just use the value return by INSTR() ^_-