Excel: Formula. Fin+nd a value in a table


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
EJKOPQRSTUVWX
3
4
5DESC2010201212345678910
6azul100500A276549870
7amarillo300A2
8verde500A1
9blanco1A
10turquesa40A5
11moradoA3
12naranjado836A4
13negro20
14gris45E35
15rosado90E3
16pastel100056E
17fucsia100E312
18mono200E2
19gato78
20conejo300E31
21tigre50E8
22leon56E311
23gorila10E315
24chimpance100E3121
25oso0H
26tiburon020H4567143
27avion20K
28barco3034K1
29camion6023K2
30

INC



RESULT REQUIRED Excel 2003
ABCD
1INDEXDESC20102012
2Ablanco1
3Epastel100056
4Hoso0
5Kavion20
6A1verde500
7A2amarillo300
8A3morado
9A4naranjado836
10A5turquesa40
11E2mono200
12E3rosado90
13E8tigre50
14K1barco3034
15K2camion6023
16E31conejo300
17E35gris45
18E311leon56
19E312fucsia100
20E315gorila10
21E3121chimpance100
22H4567143tiburon020
23A276549870azul100500
24

ORX




This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of October 24, 2014.


For more resources for Microsoft Excel