I have a mailing list that I receive monthly. I have to mail one of ten
letters to each zip code on the list. I have another list that shows which
letter goes with each zip code. Currently I have to manually go thru the list
line by line, compare the zip codes on the two lists, and type in the letter
that should be sent.

Is there a formula I can use to automatically populate the 'letter' field
for me so I don't have to manually compare the two lists each month?

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Erdmann89" wrote in message
...
I have a mailing list that I receive monthly. I have to mail one of ten
letters to each zip code on the list. I have another list that shows which
letter goes with each zip code. Currently I have to manually go thru the
list
line by line, compare the zip codes on the two lists, and type in the
letter
that should be sent.

Is there a formula I can use to automatically populate the 'letter' field
for me so I don't have to manually compare the two lists each month?