When using the VLOOKUP function on a table array with data returned from a data source query, I found it necessary to explicitly convert my lookup value to a text value. Failing to do so normally resulted in a error.
=VLOOKUP(TEXT(A1,0),Table_Query_from_My_Data_Source,2,FALSE)
