VLookup Problem
 

I've got the following code, but it returns "#REF!" into the cell that
I was expecting the value - can anyone tell me what I've done wrong?

I've double checked and it should be finding something in the target
workbook:

----------

Sub Find_Values()
Dim CustNo As String
CustNo = "GB-NAA001"
Address = Application.VLookup(CustNo, Workbooks("2009-05
Server_Utilisation.xls").Sheets("Server_Utilisatio n").Range("$C$25:$C
$1000"), 3, False)
Range("A1") = Address
End Sub

-----------

Many thanks for any advice.

VLookup Problem
 

It doesn't like the value "3" in the end of the VLookup command, if I
change it to 1 it works fine but I don't want to return the value I am
looking for - how can I get the value back from the same row but for
columns "I" and "O" etc?

VLookup Problem
 

Ignore me, of course you have to include in the range the columns you
want returning, sorry to waste your bandwidth, this worked:

Address = Application.VLookup(CustNo, Workbooks("2009-05
Server_Utilisation.xls").Sheets("Server_Utilisatio n").Range("$C$25:$I
$1000"), 3, False)

VLookup Problem
 

in the "Immediate" window, out this
? Application.VLookup(CustNo, Workbooks("2009-05
Server_Utilisation.xls").Sheets("Server_Utilisatio n").Range("$C$25:$C
$1000"), 3, False)

and see what happens.



"David" wrote in message
...
I've got the following code, but it returns "#REF!" into the cell that
I was expecting the value - can anyone tell me what I've done wrong?

I've double checked and it should be finding something in the target
workbook:

----------

Sub Find_Values()
Dim CustNo As String
CustNo = "GB-NAA001"
Address = Application.VLookup(CustNo, Workbooks("2009-05
Server_Utilisation.xls").Sheets("Server_Utilisatio n").Range("$C$25:$C
$1000"), 3, False)
Range("A1") = Address
End Sub

-----------

Many thanks for any advice.