If you *are* using ADO, you could use a disconnected recordset (i.e.
client-side cursor) and a cursor type which supports bookmarks (e.g.
static cursor) and retain the recordset object by keeping it in scope
somehow (e.g. module-level variable). When you wanted to find a row
based on a column value, you could go back to your recordset and apply
a filter using its Filter property e.g.

With MyRecordset
.Filter = "invoice_nbr = 'EN030544'"
If .RecordCount 0 Then
' Do something with filtered rows
End If
End With

Look up Filter in the help:

http://msdn.microsoft.com/library/de...dprofilter.asp

Otherwise, you may find it a better approach to hit the database each
time, rather than filter the results in the Excel GUI e.g.

SELECT ...
FROM ...
WHERE invoice_nbr = 'EN030544'

--

JWolf wrote in message ...
Syntax

VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

Have you tried setting range_lookup to FALSE ?

jjanzen wrote:
Raul,

Thanks. That solved the problem where I lookup numbers which are
integers. However, I also need to use VLOOKUP on a column of data which
returns integers as well as text/number combinations. For example 62202
is one invoice number, while another is EN030544.

Is it possible to have one column returned as integers and the other as
text? I tried doing this with no success. I am an SQL rookie so maybe
I am doing something wrong. If I can return the 'combination' column as
text, I should be able to get the VLOOKUP working.

NOTE: I am using linked tables if that makes a difference.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!