help

[soumyajit]

[pre]

PLAYER NAME   IDENTITY CODE	POINT
A		22		12
B		25		11
C		65		10
D		23		9
E		11		8
F		44		7
G		85		6
H		18		5
I		84		4
J		98		3
K		67		2
L		77		1

as we can see the above shown database contains three headers(PLAYER NAME,IDENTITY CODE,POINT)

I just wanted when i enter a IDENTITY CODE in D1 cell the PLAYER NAME & POINT automatically appear in E1 & F1 cells,not only that I also wanted when i enter a IDENTITY CODE in D1 cell the above cell data will also appear automatically in D2(IDENTITY CODE) &  PLAYER NAME, POINT in E2 & F2.For example,when i entered "18"(IDENTITY CODE) in D1 the H & 5(PLAYER NAME & POINT)automatically appear in E1 & F1 and in D2,E2&F2 the above data which is 85,G & 6( IDENTITY CODE,PLAYER NAME & POINT) will also appears automatically.

IDENTITY CODE   IDENTITY CODE     POINT
D1  18 	         E1    H		F1 5
D2  85 	         E2    G		F2 6

[/pre]
this is exactly the same what I want.

 

[vasim]

E1 = =INDEX(A1:A12,MATCH(D1,B1:B12,0))

F1 = =INDEX(C1:C12,MATCH(D1,B1:B12,0))

D2 = =INDEX(B1:B12,MATCH(D1,B1:B12,0)-1)

E2 = =INDEX(A1:A12,MATCH(D2,B1:B12,0))

F2 = =INDEX(C1:C12,MATCH(D2,B1:B12,0))


Freeze range as required...