Index/ Match not working

Can someone have a look at the attached worksheet and see if you can work out why certain index/ match formulas are showing a zero result in sheet "X47"? There will be an odd case where the 2 will not match due to the date not being in sheet "X08" but mostly will be evident. The reason I am doing this is because the code I have to do it sometimes skips data and I was trying to work out why but the index/ match is not working at all for some reason.
Thanks in advance

Your formula should be just this:

=INDEX('X08'!B$2:B$4434,MATCH('X47'!B2,'X08'!I$2:I$4434,0))

And not

=INDEX('X08'!B$2:B$4434,MATCH('X47'!B2,'X08'!I$2:I$4434,0),MATCH('X47'!A2,'X08'!A$2:A$4434,0))

Your formula only references one key field when I need mine to reference both.

Formula in X2, then dragged
ARRAY Formula

Please Login or Register  to view this content.

Look at the first part of your formula... 'X08'!B$2:B$4434. Its looking only at one column.

=INDEX(RANGE, ROW_MATCH, COLUMN_MATCH). The second Match you have can't be used since you are only referencing a single column's data (column B).

kvsrinivasamurthy, That works perfectly, Can you tell me why that works but the code skips the odd one for example row 4408, 4282 & 4383?

Sorry maybe I was unclear I mean in the macro why would they not be working not in the formula.