使用Excel 2010的简单HLOOKUP失败

I have an Excel spreadsheet (generated by spreadsheet gear, but it's more an Excel problem) that isn't functioning as i would expect when I use I have an Excel spreadsheet (generated by sprea