Lining-up multiple columns of data using ISNC, INDEX, MATCH and COLUMN

Hello,

I hope someone in the community can help me as I have 4 very large files to line-up for dates along with the connected data in 5 seperate columns.

 

After many tries and searching the internet, my final try was creating a formula using ISNA, INDEX, MATCH and COLUMN but it returns #REF...

 

Here is the formula I tried: =IF(ISNA(MATCH(A4,C4:C5082,0)),"",INDEX(C4:I5082,MATCH(A4,C4:C5082,0)))

 

Here is a copy of what I am trying to line-up:

15.06.98	23.03.2004	190	190	190	190	0
16.06.98	24.03.04	201	211.5	200	208.5	7368490
17.06.98	25.03.04	210	220.5	209	219	2407527
18.06.98	26.03.04	222	224.5	215	219	1626403
19.06.98	29.03.04	217	217	213	215	366627
22.06.98	30.03.04	215.5	216	212	213.5	522775
23.06.98	31.03.04	215.5	215.5	212	212.5	380379
24.06.98	01.04.04	213	219	213	219	393132

 

 

As you can see, the dates in Column A and B do not line up and the data in columns B through G are all connected (need to stay together as shown). I would like to create a formula whereby the dates in columns A and B match and, if there is no date (and associated data) for the date in column A, then that row should stay blank or places 0 in the row.

 

Is there a formula which can achieve this or do I have to create multiple formulas? and if so, which ones?