I update a spread sheet with a name in one column that uses letters and
numbers and then manually put in a numeric value in the ajoining column. I'd
like to automate this process. I need to be able to search a list of 35-40
names and then have excel place a predefined number in the next column.