Sussed it from ozgrid - excellent site

LookUp range defined as:

=OFFSET(Contents!$F$1,0,0,COUNTA(Contents!$F:$F),2)

and VLOOKUP(A1,LookUp,2,FALSE)

Much more satisfying when you can find the answer yourself but has took me 2 days to work it out