cell not display result even formula result indicate result is correct

[7ryota]

hi,
i need help on excel, I already written a visual basic code to download the data. However i need to convert the raw data into a table format.
on the left are the raw data downloaded and i need to convert them into the table on the right
Capture.JPG
pls see the image below, for cell G5, the formula result indicate i get the formula correct, it is pointing to B16 but the result will not be indicate in the cell G5Capture1.JPG

i have attached my excel sheet
http://s000.tinyupload.com/?file_id=...21399228990576