index+match with row&column criteria

[kelvin_9]

Hi All,
can anyone tell me what's wrong with my formula here
i cant return the numbers what i want

thank you so much for helping me out

Book1
	A	B	C	D	E
1	ITEM	91000111	91000117	91000118	91000119
2	4.00051E+11	4.00051E+11	513	0	257
3
4
5		91000111	91000117	91000118	91000119
6	4.00051E+11	513	0	257	0
7	4.00051E+11	193	0	319	0
8	4.00051E+11	551	0	455	0
9	4.00051E+11	0	0	0	0
Sheet2

 

[Fluff]

You need to change the index range to start at B6 not A6

 

[kelvin_9]

You need to change the index range to start at B6 not A6

AWESOME
THANK YOU VERY MUCH Fluff

 

[Fluff]

You're welcome & thanks for the feedback.