Formula. Fin+nd a value in a table

[Alejandro Rodriguez]

Hello,

Which formula I need to accomplish the below results.

I tried with

=INDEX(INC!E:E,MATCH(A2,INC!O:X,0))

but doesnt work

Thank you for your help.


MY TABLE

Excel 2003
	E	J	K	O	P	Q	R	S	T	U	V	W	X
3
4
5	DESC	2010	2012	1	2	3	4	5	6	7	8	9	10
6	azul	100	500										A276549870
7	amarillo		300		A2
8	verde	500			A1
9	blanco		1	A
10	turquesa	4	0		A5
11	morado				A3
12	naranjado	8	36		A4
13	negro	20
14	gris		45			E35
15	rosado	90			E3
16	pastel	1000	56	E
17	fucsia	100					E312
18	mono	200			E2
19	gato		78
20	conejo	300				E31
21	tigre	50			E8
22	leon		56				E311
23	gorila	10					E315
24	chimpance		100					E3121
25	oso	0		H
26	tiburon	0	20								H4567143
27	avion	20		K
28	barco	30	34		K1
29	camion	60	23		K2
30
INC

RESULT REQUIRED

Excel 2003
	A	B	C	D
1	INDEX	DESC	2010	2012
2	A	blanco		1
3	E	pastel	1000	56
4	H	oso	0
5	K	avion	20
6	A1	verde	500
7	A2	amarillo		300
8	A3	morado
9	A4	naranjado	8	36
10	A5	turquesa	4	0
11	E2	mono	200
12	E3	rosado	90
13	E8	tigre	50
14	K1	barco	30	34
15	K2	camion	60	23
16	E31	conejo	300
17	E35	gris		45
18	E311	leon		56
19	E312	fucsia	100
20	E315	gorila	10
21	E3121	chimpance		100
22	H4567143	tiburon	0	20
23	A276549870	azul	100	500
24
ORX

 

[Alejandro Rodriguez]

ok Rick . thank you so much, again.

 

[Aladin Akyurek]

Which interpretation did you have in mind if any?

 

[Alejandro Rodriguez]

Aladin,

In your post #5 you said that ...A2 is in fact the look up value and B2:D2 are the results..., which is right.
I wasn't clear in my first post that I needed that.

Thank you so much.

 

[Aladin Akyurek]

Aladin,

In your post #5 you said that ...A2 is in fact the look up value and B2:D2 are the results..., which is right.
I wasn't clear in my first post that I needed that.

Thank you so much.

Ok, thanks. Another question if I may. The sample you posted shows just one value, anycase newer two in O:X. Is your data really like that as I assumed?

 

[Alejandro Rodriguez]

Aladin,

Actually my data has many duplicates in O:X. But I solved that with a filter and getting only unique values. Because in this particular case I only needed the information of those unique values.

 

[Aladin Akyurek]

Aladin,

Actually my data has many duplicates in O:X. But I solved that with a filter and getting only unique values. Because in this particular case I only needed the information of those unique values.

Thanks for the information.