I understand that. The problem is that in order to have the SQL.REQUEST
function work you need to have Excel ODBC installed and I can't find where to
get that for Excel 2003 version. On the microsoft website they do have the
download available, but it is for Excel 2002 and XP versions-- will not work
on Excel 2003 version. This makes no sense because it is in Excel 2003 Help
that it states "If this function is not available, you must install the
Microsoft Excel ODBC add-in program. You can install the add-in from the
Microsoft Office Web site." Yet I can't find it on the website and it is not
already installed in Excel 2003 version. ??????????

"Harlan Grove" wrote:

Andy Wiggins wrote...
You should be able to do this using SQL.REQUEST.
....

If SQL.REQUEST works, VLOOKUP would be unnecessary since the SQL Select
statement could pull the desired value directly from the SQL Server
table(s).