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)