How to convert the vlookup function from excel to access

See the attachments
lookup.xlsx
Jone ElliaAsked:
Who is Participating?
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi Jone,

Glad you made it here. Welcome to Experts Exchange.

I made a video on "converting" vLookup in Excel to Access, which I believe you saw.  The point of that video is that often there is no need to "convert" those formulas since, in Access, you can use a query and link the tables. For others reading, here that video:
https://www.youtube.com/watch?v=ED_Wd4w9PLk

The first step would be to create the tables in Access.  Then make a query, join the tables, and get what you want out of each one.  I did not download the example Bill gave you, but I assume that is what he did for you.

When you post a question, be sure to describe what you need and where information to look at is located.

have an awesome day,
crystal
0
 
Bill PrewCommented:
Depending on how your database tables are laid out, you should be able to use the DLOOKUP() function in Access to do similar things.  Further info below...



»bp
0
 
Jone ElliaAuthor Commented:
thanks a lot Bill Prew
but how can i create a same function in the access?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Bill PrewCommented:
In the example Excel file, it looks like you are doing a matching process.  That can be done in Access using an Outer Join.  Attaching a sample Access database with your two main columns of data as tables tblInput, tblLookup), and then created a Select Query (qryMatch)  that joins the two tables matching on the number column.  When you run the query you will see the results similar to your middle column in Excel.

Without knowing any more about what you are trying to do this was what I came up with, hope it gives you the idea of what's possible.

EE29077570.accdb


»bp
0
 
Jone ElliaAuthor Commented:
many many thanks ,Bill Prew and cristal
it was very useful
0
 
Bill PrewCommented:
Glad you got something useful.  For future reference, you can select "assisted" comments as well as a single "solution" when you close a question.  Perhaps you know that, and felt only one comment here was helpful, which is fine, but wanted to make sure you knew that you can recognize more than one useful comment when it's appropriate to you.

Take a look at this article, it should help you with the question close process.


For future reference here some other items related to closing questions in case they are helpful.


And don't forget you can always "request attention" on a question if you are not sure how to proceed and a support person will be in touch to help you out.



»bp
1
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome, Jone ~ happy to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.