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.