VLOOKUP

  • Thread starter Thread starter Ian Muller
  • Start date Start date
I

Ian Muller

Does the VLOOKUP formula work in Access? I am trying to
write a formula/expression in a Query, asking the query
to look up a value in a table column and then using a
corresponding value in another column, in my query
formula.

Regards

Ian
 
Ian,

The equivalent of Excel VLookup function is Access is DLookup (look it up in
help). In a query, though, it is quite easier, and probably more efficient
to add and join the table you want to llokup a value from.

HTH,
Nikos
 
Back
Top