I'm pretty uneducated on excel but am trying to develop a master list of
coded infomation that I can simply type a "code number or item number" which
will then input the saved info for that "item number" into the adjoining
cell, along with a cost associated with that item number. Where do I save
this "master list" of info so that when I begin to type the "code" or even
begin typing info into a cell, my "master list" of info will auto fill, or
give me choices of saved info that i'd like to have put in that cell.

Please help. Thanks