VLOOKUP in Access
By Richard Rost 2 years ago
Access Equivalent of Excel VLOOKUP Function
In this video, I'll show you how to perform the equivalent of the VLOOKUP function from Excel in Microsoft Access using DMax and DLookup. We will look up letter grades for students based on their test scores.
Alyssa from Baltimore, Maryland (a Gold Member) asks: I know how to use the VLOOKUP function in Excel to figure out letter grades from test scores. How can I do the same thing in Access?
Members will learn how to create a GetLetterGrade global function so this lookup can be performed anywhere in the database without extra steps.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, dlookup, vlookup, dmax, Access Equivalent of Excel VLookup, Excel-Like VLookup for Microsoft Access, Can I do VLookup in access, How to do a VLookup in access
Subscribe to VLOOKUP in Access
Get notifications when this page is updated