Result from either VLOOKUP or INDEX/MATCH put under correct column

[BradleyS]

How to I test the result from either VLOOKUP or INDEX/MATCH and then put it under the relevant column?

I have entered 2 examples below of where I would like the values to show because they are within the value range for each ID
I can't seem to add the greater than or less than elements to either formula to get it to work.

Here is my data:

Excel 2010
	A	B	C	D	E	F	G	H	I
1	id	eventdate	value		id	Value <59	Value >=59 <=64	Value >=65 <=74	Value>=75
2	3	22/06/2015	50		3	50
3	69	03/04/2014	69		7
4	108	28/04/2014	49		9
5	153	16/05/2014	55		69			69
6	168	19/05/2014	65		108
7	177	29/05/2014	47		110
8					135
9					153
10					168
11					177
Sheet39

Cell Formulas
Range	Formula
F2	=VLOOKUP(E2,A1:C7,3,FALSE)
H5	=INDEX(C1:C7,MATCH(E5,A1:A7,0))

 

[Fluff]

Could you have a situation where the same id appears twice & both have a value in the same range like

Excel 2013/2016
	A	B	C
1	id	eventdate	value
2	3	22/06/2015	50
3	69	03/04/2014	69
4	108	28/04/2014	49
5	153	16/05/2014	55
6	168	19/05/2014	65
7	177	29/05/2014	77
8	3	29/06/2014	40
Calc

If so, what do you want as a result?

 

[BradleyS]

No the ID's in both tables are unique and will only appear once. However, the end result table E-I will have more ID's and therefore some may not have values that are in the 1st table A-C

 

[Fluff]

In that case if you are happy to change the headers you could use

Excel 2013/2016
	A	B	C	D	E	J	K	L	M
1	id	eventdate	value		id	59	64	74	75
2	3	22/06/2015	50		3	50	0	0	0
3	69	03/04/2014	69		7	0	0	0	0
4	108	28/04/2014	49		9	0	0	0	0
5	153	16/05/2014	55		69	0	0	69	0
6	168	19/05/2014	65		108	49	0	0	0
7	177	29/05/2014	77		110	0	0	0	0
8					135	0	0	0	0
9					153	55	0	0	0
10					168	0	0	65	0
11					177	0	0	0	77
Calc

Cell Formulas
Range	Formula
J2	=SUMIFS($C:$C,$A:$A,$E2,$C:$C,"<="&J$1)
K2	=SUMIFS($C:$C,$A:$A,$E2,$C:$C,"<="&K$1,$C:$C,">"&J$1)
L2	=SUMIFS($C:$C,$A:$A,$E2,$C:$C,"<="&L$1,$C:$C,">"&K$1)
M2	=SUMIFS($C:$C,$A:$A,$E2,$C:$C,">="&M$1)

 

[BradleyS]

I'm happy to change the headers, so yes that would work fine. Thank you

 

[Fluff]

You're welcome & thanks for the feedback