Good afternoon Kateabc

...and welcome to the forum!!

Chip Pearson discusses this very subject on his site - you might like to have a look, he also provides an example to download.

http://www.cpearson.com/excel/TablesAndLookups.aspx
http://www.cpearson.com/Zips/Lookups2.zip

HTH

DominicB