function ACCESS the VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
On Thu, 15 Jun 2006 06:23:02 -0700, humberto martinez <humberto
is there an equivalent function in ACCESS to the VLOOKUP function?
Click to expand...

Short answer:

Yes, DLookUp

Deeper answer:

Access and Excel are VERY DIFFERENT PROGRAMS. The tools that you use
in Access may very well be different, and be used differently, than
what you're used to in Excel. It's very likely that the (rather
inefficient) DLookUp function will *not* be needed, because what
you're trying to accomplish may be better done by using a Query
joining two tables.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel IF statement with vlookup 2
Vlookups not working 2
VLOOKUP 2
VLookup not working - missing entries or not returning correct values 1
EXCEL - IF(IFERROR(VLOOKUP question 0
What is the VBA equivalent of the excel function VLOOKUP 4
Can't Explain N/A in Vlookup 2
Set add function ignore #N/A 1

Back
Top