VLOOKUP against an MS Query

  • Thread starter Thread starter SPF40
  • Start date Start date
S

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?
 
I tried SQL already and it was way too slow. So its impossible to use MS
QUERY with VLOOKUP?


Harald Staff said:
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 said:
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?
Click to expand...
Click to expand...
 
Back
Top