I have read loads of threads on this but I can't seem to get it to return what I want.

I have a 13 digit unique number which I want to match against an entry in another workbook. I can get the number to match so it returns the cell value it matched against but I want it to return the value of the column to the right of the matching cell.

=VLOOKUP(E16,'[Housing Data included within British Gas On Contract 140611.xls]Housing With Annualised Figures'!$H:$H,1,FALSE)

Any suggestions?

Thanks
John