Hi Ron-
Yes, I have a separate listing of area codes and their corresponding
city & state. How could I set up document A's columns to consult the
second document to autofil the City and State fields?

Thanks,

Biz


--
Biz
------------------------------------------------------------------------
Biz's Profile: http://www.excelforum.com/member.php...o&userid=16354
View this thread: http://www.excelforum.com/showthread...hreadid=483646