cell not display result even formula result indicate result is correct

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

Please upload the file directly to the forum as many will not download from file services.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I think that I have what you are looking for. I changed the formula in F4 to the following and filled across and down.

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

I forgot the second worksheet.
Formula for Monthly Data G4 filled across and down is

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

A non-array formula option:

=IFERROR(LOOKUP(2,1/(($C$5:$C$1060=$E4)*($D$5:$D$1060=G$3)),$B$5:$B$1060),"")

Enter only

=IFERROR(INDEX($B$5:$B$1060,MATCH($E4&F$3,$C$5:$C$1060&$D$5:$D$1060,0),0),"")
IFERROR - This function returns a value (which is at the end of the formula) if the formula returns an error value. In this case it is "" or a null value for the cell.
INDEX - This function identifies where the data is that you want to retrieve. In this formula the values are in column B. INDEX has 3 arguments. The first is the ARRAY or range of cells, the second is the ROW where the data wanted is to be found and the third argument is the COLUMN where the data is to be found. In this formula we know that the data to be retrieved is in one column and it has been identified by the INDEX ARRAY argument so a column argument will not be required.
MATCH - has 3 arguments: A Value, an ARRAY and the type of match. usually the match is a simple match of a value within a range. However here we have the concatenation of the values in E4 and F3 to be found in the combination of the columns E and F. The type of match is indicated by the 0 which corresponds to FALSE (exact). MATCH can also have a value of +1 or -1. +1 or omitted finds the largest value that is less than or equal to the lookup value. -1 finds the smallest value that is greater than or equal to the lookup value. We want an exact match so the 0 is used.
The last 0 in the formula can be omitted. It is the column number and we already know that there is only 1 column and it has been identified so the 0 is really unnecessary.

The formula is an array formula because of the combining of elements to be evaluated against another combination of elements.

bebi921999 has a non array formula and perhaps could supply you an explanation of the LOOKUP formula provided.