Auto Fill a Referenced Table

Hi there! I'm looking to set up a table in Excel (or possibly Access that is then referenced through Excel). But end goal would be to be able to type in an Item Number and then Excel automatically fills in the Description, weight, price and other information about that item number. That way, I don't have to type in "11108.1" and "Computer Mouse" and "$15.98". I want to only type in "11108.1" and it knows to fill in the other information. Is this possible in Excel? I've searched through many functions and haven't found it so I'm thinking it may require a combination of formulas.

Thanks in advance for the assistance!!

Hi,

Welcome to the Forum.

This is possible by defining "Names" in Data Validation -> List. Please post a sample template of your workbook using "Go Advanced" option below (with enough samples in it).