Apply index and Match to retrieve a value

[mcva]

Hi, I need some help with this problem. I have included a figure that describes the excel problem.
I really don't know how to start from. I have tried vlookup and hlookup but I think that this can't be done with these two functions.

I need to retrieve the values in column G (in blue), from table I30 to N30, considering two conditions:
1) The text in columns B and columns I must be the same (green with green)
2) the text in column C and in row J2 to N2 must be the same (oranje with orange)
Thank you so much,

 

[felixstraube]

How about?:

=FILTER(FILTER($J$3:$N$30, $I$3:$I$30 = B2), $J$2:$N$2 = C2)

Libro1
	B	C	D	E	F	G	H	I	J	K	L	M	N
2	Name01	a				1			a	b	c	d	e
3	Name01	b				29		Name01	1	29	57	85	113
4	Name01	c				57		Name02	2	30	58	86	114
5	Name01	d				85		Name03	3	31	59	87	115
6	Name01	e				113		Name04	4	32	60	88	116
7	Name02	a				2		Name05	5	33	61	89	117
8	Name02	b				30		Name06	6	34	62	90	118
9	Name02	c				58		Name07	7	35	63	91	119
10	Name02	d				86		Name08	8	36	64	92	120
11	Name02	e				114		Name09	9	37	65	93	121
12	Name03	a				3		Name10	10	38	66	94	122
13	Name03	b				31		Name11	11	39	67	95	123
14	Name03	c				59		Name12	12	40	68	96	124
15	Name03	d				87		Name13	13	41	69	97	125
16	Name03	e				115		Name14	14	42	70	98	126
17								Name15	15	43	71	99	127
18								Name16	16	44	72	100	128
19								Name17	17	45	73	101	129
20								Name18	18	46	74	102	130
21								Name19	19	47	75	103	131
22								Name20	20	48	76	104	132
23								Name21	21	49	77	105	133
24								Name22	22	50	78	106	134
25								Name23	23	51	79	107	135
26								Name24	24	52	80	108	136
27								Name25	25	53	81	109	137
28								Name26	26	54	82	110	138
29								Name27	27	55	83	111	139
30								Name28	28	56	84	112	140
Hoja1

Cell Formulas
Range	Formula
G2:G16	G2	=FILTER(FILTER($J$3:$N$30,$I$3:$I$30=B2),$J$2:$N$2=C2)

 

[Georgiboy]

Index/ match/ match should work:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Data	cc	pp	uu	ll	v	VLE
2	06/12/2023	d	d				4		blah	a	b	c	d	e
3	07/12/2023	f	c				3		a	1	2	3	4	5
4	08/12/2023	i	e				5		b	1	2	3	4	5
5	09/12/2023	l	a				1		c	1	2	3	4	5
6	10/12/2023	q	b				2		d	1	2	3	4	5
7	11/12/2023	aa	d				4		e	1	2	3	4	5
8									f	1	2	3	4	5
9									g	1	2	3	4	5
10									h	1	2	3	4	5
11									i	1	2	3	4	5
12									j	1	2	3	4	5
13									k	1	2	3	4	5
14									l	1	2	3	4	5
15									m	1	2	3	4	5
16									n	1	2	3	4	5
17									o	1	2	3	4	5
18									p	1	2	3	4	5
19									q	1	2	3	4	5
20									r	1	2	3	4	5
21									s	1	2	3	4	5
22									t	1	2	3	4	5
23									u	1	2	3	4	5
24									v	1	2	3	4	5
25									w	1	2	3	4	5
26									x	1	2	3	4	5
27									y	1	2	3	4	5
28									z	1	2	3	4	5
29									aa	1	2	3	4	5
30									bb	1	2	3	4	5
Sheet1

Cell Formulas
Range	Formula
G2:G7	G2	=INDEX($J$3:$N$30,MATCH(B2,$I$3:$I$30,0),MATCH(C2,$J$2:$N$2,0))

 

[mcva]

Index/ match/ match should work:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Data	cc	pp	uu	ll	v	VLE
2	06/12/2023	d	d				4		blah	a	b	c	d	e
3	07/12/2023	f	c				3		a	1	2	3	4	5
4	08/12/2023	i	e				5		b	1	2	3	4	5
5	09/12/2023	l	a				1		c	1	2	3	4	5
6	10/12/2023	q	b				2		d	1	2	3	4	5
7	11/12/2023	aa	d				4		e	1	2	3	4	5
8									f	1	2	3	4	5
9									g	1	2	3	4	5
10									h	1	2	3	4	5
11									i	1	2	3	4	5
12									j	1	2	3	4	5
13									k	1	2	3	4	5
14									l	1	2	3	4	5
15									m	1	2	3	4	5
16									n	1	2	3	4	5
17									o	1	2	3	4	5
18									p	1	2	3	4	5
19									q	1	2	3	4	5
20									r	1	2	3	4	5
21									s	1	2	3	4	5
22									t	1	2	3	4	5
23									u	1	2	3	4	5
24									v	1	2	3	4	5
25									w	1	2	3	4	5
26									x	1	2	3	4	5
27									y	1	2	3	4	5
28									z	1	2	3	4	5
29									aa	1	2	3	4	5
30									bb	1	2	3	4	5
Sheet1

Cell Formulas
Range	Formula
G2:G7	G2	=INDEX($J$3:$N$30,MATCH(B2,$I$3:$I$30,0),MATCH(C2,$J$2:$N$2,0))

Thank you very much. Works fine

 

[mcva]

Index/ match/ match should work:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Data	cc	pp	uu	ll	v	VLE
2	06/12/2023	d	d				4		blah	a	b	c	d	e
3	07/12/2023	f	c				3		a	1	2	3	4	5
4	08/12/2023	i	e				5		b	1	2	3	4	5
5	09/12/2023	l	a				1		c	1	2	3	4	5
6	10/12/2023	q	b				2		d	1	2	3	4	5
7	11/12/2023	aa	d				4		e	1	2	3	4	5
8									f	1	2	3	4	5
9									g	1	2	3	4	5
10									h	1	2	3	4	5
11									i	1	2	3	4	5
12									j	1	2	3	4	5
13									k	1	2	3	4	5
14									l	1	2	3	4	5
15									m	1	2	3	4	5
16									n	1	2	3	4	5
17									o	1	2	3	4	5
18									p	1	2	3	4	5
19									q	1	2	3	4	5
20									r	1	2	3	4	5
21									s	1	2	3	4	5
22									t	1	2	3	4	5
23									u	1	2	3	4	5
24									v	1	2	3	4	5
25									w	1	2	3	4	5
26									x	1	2	3	4	5
27									y	1	2	3	4	5
28									z	1	2	3	4	5
29									aa	1	2	3	4	5
30									bb	1	2	3	4	5
Sheet1

Cell Formulas
Range	Formula
G2:G7	G2	=INDEX($J$3:$N$30,MATCH(B2,$I$3:$I$30,0),MATCH(C2,$J$2:$N$2,0))

Thank you very much.

 

[Georgiboy]

You're welcome, thanks for the feedback.