If I understood your post correctly then you need the following
*array* formula:

=INDEX('[Introductory Payments Feb new download.xls]Left to Spend
07-08'!F$7:F$65,MATCH(B3,LEFT('[Introductory Payments Feb new
download.xls]Left to Spend 07-08'!D$7:D$65,5),0))

As it is an array formula, commit with Shift+Ctrl+Enter.

HTH
Kostis Vezerides

On Mar 28, 2:59 pm, Joe wrote:
What's the best way for this?
I am using a Vlookup. I am looking to return values for the ones attached to
codes like 53500, 535001. My problem is that in the Array Table the this code
comes attached to a name eg 53500Hotel XXX.

I don't want to split the table array. Is there any smart way to for
instance tell the Vlookup to look for the first 5digits in the first column
of the array table?

Formula so far: =VLOOKUP(B3,'[Introductory Payments Feb new
download.xls]Left to Spend 07-08'!D$7:F$65,3,FALSE)