Looking for Access function which = Excel function "VLOOKUP"

[Guest]

I am looking for the function (or formula, or setting) that does the same as
the Ecxel function "VLOOKUP". If anyone know the answer, I would really
apreciate the answer. Thank you...

 

[John Vinson]

On Thu, 9 Jun 2005 11:29:31 -0700, "L.J.R. Robert" <L.J.R.

I am looking for the function (or formula, or setting) that does the same as
the Ecxel function "VLOOKUP". If anyone know the answer, I would really
apreciate the answer. Thank you...

Short answer:

DLookUp

Correct answer:

Excel is a spreadsheet, a good one. Access is a relational database.
THEY ARE DIFFERENT! Trying to force Access to work as a "big
spreadsheet" will be a major exercise in frustration. Sometimes, using
DLookUp is an appropriate solution, depending on the problem; but very
often you'll do better to use a Query joining two tables, or a Combo
Box on a form, or some other *database* solution. If you'll describe
the problem you're trying to solve (rather than a Procrustean solution
"make this work just like Excel") we'll be glad to help find the
proper approach.

John W. Vinson[MVP]

 

[Guest]

Access and Excel are different. "VLOOKUP" is the equivalent of an Update
Query or a Select Query. For example, in accounting we have accounts and
account names. If you make sure that you have one and only one account number
and name relationship then you can link the tables based on account number
and substitute the account name. The idea of a relational database is my
vision of a continuous vlookup. You can construct far greater complexities in
Access in this manner. Sorry for a generic answer to the question.