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 23,D & 9( IDENTITY CODE,PLAYER NAME & POINT) will also appears automatically.
IDENTITY CODE IDENTITY CODE POINT
D1 18 E1 H F1 5
D2 23 E2 D F2 9
this is exactly the same what I want.help me plz.
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 23,D & 9( IDENTITY CODE,PLAYER NAME & POINT) will also appears automatically.
IDENTITY CODE IDENTITY CODE POINT
D1 18 E1 H F1 5
D2 23 E2 D F2 9
this is exactly the same what I want.help me plz.
