In Access, Data is stored in tables. You will need to import your Excel worksheet into an Access table or link it. Then for your items that you need to lookup, you would build tables with your lookup values. Lookups are best done in forms. Look at this link as to why you should not do look ups from tables.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.