LookUp from One sheet to other in Acces

aravindkm

New member
Joined
Mar 13, 2014
Messages
19
Reaction score
0
Points
0
Excel Version(s)
2013
Hi,

Could anyone please help me on access to paste the sheet1 "WS data" and should use the lookup from other sheets.

Thanks
 

Attachments

  • Test.xlsx
    114.8 KB · Views: 13
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.

http://access.mvps.org/access/lookupfields.htm
 
Alan, this thread is one year old. Not much chance of getting an answer...
 
Back
Top