Tom Ogilvy Wrote:
No. Vlookup won't work with data resident in Access. If you used a
query
table to bring it into Excel, then you could use vlookup against the
returned
data.

--
Regards,
Tom Ogilvy


"sal21" wrote:


assuming i have this code, is possible to use this vlookup withnthe
adta
into mdb access?...

old scenario:
Private Sub TextBox25_Change()
Dim CODICE As Integer
Select Case Me.TextBox25
Case ""
Me.TextBox4 = ""
Case 1 To 8
CODICE = Val(Me.TextBox25)
Me.TextBox4 = Application.WorksheetFunction.VLookup _
(CODICE, Worksheets("TABELLA").Range("Q2:R9"), 2, False)
Case Else
Call MULTI_LINE_BOX
End Select
End Sub


new scenario:
Inested column Q and R in excel i have created a mdb into:

\\my server\myserverdir\USER.MDB

and into this mdb have inserte a table USER_NAME with:

Field1(with the same data of column R)
Field2(with the same data of column Q)

is possible now to make a vlookup?

EXAMPLE:
Filed1 Field2
OI14006 PPPPPPPPPP
OI15535 GGGGGGGGGGGG
OI15795 HHHHHHHHHHHHH
OI16135 HDSFDDFDFD
OI16696 DFFDFDFDSFD
OI16780 EREREWERERWER
OI16821 AAAADSDASDAD



+-------------------------------------------------------------------+
|Filename: USER.zip
|
|Download: http://www.excelforum.com/attachment.php?postid=4530
|

+-------------------------------------------------------------------+

--
sal21



------------------------------------------------------------------------
sal21's Profile:
http://www.excelforum.com/member.php...fo&userid=2040
View this thread:
http://www.excelforum.com/showthread...hreadid=526768



ok Tom...
but your suggestion not for me...
help me please....


--
sal21


------------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
View this thread: http://www.excelforum.com/showthread...hreadid=526768