Simulate VLookup from Excel in Access

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I was wondering if there was a way to simulate the VLookUp
() function in Excel in a Select Query. I know I could
write a nested if statement but there are 20+ logical
answers. Any ideas?

Thanks.
 
Brian,

Excel's VLookup is actually trying to simulate Access's functionality!
Access (or any relational dbms for that matter...) is light years ahead in
this. Make a separate table to hold what your lookup area would be in Excel,
and then make a query to join your original table and the new one on the
lookup value field. Take all fields required from both tables down to the
grid for output, and you're done.

HTH,
Nikos
 
Back
Top