help index and match macro not working but formula working??

Can someone help me on this

Please Login or Register  to view this content.

Formula

Please Login or Register  to view this content.

Macro giving output 0 where as formula is working??

Itemised Test formula itemised
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 2
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 2
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 2
0 1
0 1
0 1
0 2
0 2
0 1
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 2
0 3
0 3
0 3
0 4
0 4
0 4
0 4
0 5
0 6
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 2
0 2
0 2
0 2
0 2
0 2
0 7
0 8
0 9
0 10
0 11
0 12
0 13
0 14
0 15
0 15
0 15
0 15
0 16
0 16
0 16
0 17
0 18
0 19
0 6
0 6
0 6
0 6
0 6
0 20
0 20
0 21
0 21
0 21
0 21
0 21
0 22
0 23
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 25
0 25
0 25
0 26
0 26
0 27
0 28
0 28
0 29
0 29
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 31
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 32
0 32
0 33
0 34
0 35
0 35
0 36
0 35
0 37
0 37
0 37
0 38
0 39
0 39
0 39
0 35
0 40
0 41
0 42
0 42
0 43
0 44
0 44
0 38
0 38
0 45
0 42
0 46
0 6
0 20
0 2
0 47
0 47
0 47
0 48
0 48
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 25
0 49
0 29
0 29
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 31
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 50
0 50
0 33
0 35
0 35
0 35
0 35
0 38
0 35
0 51
0 52
0 33
0 33
0 53
0 54
0 55
0 55
0 56
0 5
0 57
0 58
0 2
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 2
0 1
0 1
0 1
0 1
0 2
0 2
0 1
0 59
0 60
0 60
0 61
0 61
0 62
0 12
0 63
0 64
0 64
0 64
0 64
0 64
0 64
0 65
0 66
0 67
0 67
0 67
0 67
0 67
0 67
0 67
0 68
0 68
0 68
0 68
0 16
0 17
0 69
0 70
0 70
0 70
0 71
0 6
0 72
0 6
0 6
0 6
0 6
0 6
0 6
0 6
0 20
0 73
0 74
0 75
0 74
0 76
0 76
0 77
0 22
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 24
0 25
0 25
0 25
0 49
0 49
0 49
0 49
0 29
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 31
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 30
0 32
0 32
0 32
0 32
0 32
0 32
0 34
0 34
0 34
0 35
0 35
0 78
0 35
0 37
0 35
0 35
0 35
0 35
0 35
0 37
0 37
0 37
0 37
0 37
0 53
0 53
0 53
0 53
0 53
0 53
0 53
0 79
0 80
0 81
0 82
0 45
0 83
0 84
0 84
0 40
0 85
0 85
0 85
0 85
0 44
0 86
0 33
0 33
0 33
0 33
0 38
0 54
0 87
0 80
0 88
0 80
0 85
0 85
0 89
0 42
0 90
0 90
0 91
0 92
0 93
0 94
0 94
0 95
0 95
0 96
0 97
0 98
0 90
0 90
0 90
0 99
0 100
0 100
0 100
0 100
0 101
0 102
0 103
0 104
0 104
0 105
0 105
0 106
0 107
0 107
0 108
0 108
0 91
0 109
0 110
0 111
0 112
0 113
0 113
0 113
0 113
0 113
0 114
0 115
0 116
0 117
0 118
0 118
0 119
0 120
0 121
0 121
0 121
0 122
0 30
0 123

Shouldn't it like this ?

Please Login or Register  to view this content.

Changed to 7 but now reading 11111111 in the column
C' ant figured out??

Changed to 7 but now reading 11111111 in the column
C' ant figured out??

Upload the workbook ?

See attached

You set a single array formula for the whole range in column O, while the array formula actually is just for single cell only.

So, you should put the array formula for a single cell (cell O2), and then copy down, just as your manual typed formulas.

Please Login or Register  to view this content.

Thanks for your advice and help.

Was getting with this.

Thanks you

You are welcome, and thanks for the reputation points.


Regards