VLOOKUP against an MS Query

[SPF40]

I sure could use some help performing a VLOOKUP against a closed MS
Query. I can do one against a closed spreadsheet
(VLOOKUP(A2,'G:\Public\SPF\[Book4.xls]DATA'!DATA,2,FALSE) but this
fails against MS query. Can someone please provide an example or if
its not possible, how do I create a VLOOKUP with data from an MS
Access database?

 

[Harald Staff]

Hi

You don't use VLOOKUP to databases, you use SQL. See
http://www.w3schools.com/sql/sql_where.asp

HTH. Best wishes Harald

 

[SPF40]

I tried SQL already and it was way too slow. So its impossible to use MS
QUERY with VLOOKUP?

Hi

You don't use VLOOKUP to databases, you use SQL. See
http://www.w3schools.com/sql/sql_where.asp

HTH. Best wishes Harald

I sure could use some help performing a VLOOKUP against a closed MS
Query. I can do one against a closed spreadsheet
(VLOOKUP(A2,'G:\Public\SPF\[Book4.xls]DATA'!DATA,2,FALSE) but this
fails against MS query. Can someone please provide an example or if
its not possible, how do I create a VLOOKUP with data from an MS
Access database?