pmeghnathi
Board Regular
- Joined
- Mar 11, 2018
- Messages
- 86
- Office Version
- 2003 or older
I find this sheet in kishor's marks.second row value is mark |
A | B | C | D | ||
Kishor | raju | Manish | raj | ||
45 | 60 | 25 | 3 | ||
I find this sheet in kishor's marks.second row value is mark |
A | B | C | D | ||
Kishor | raju | Manish | raj | ||
45 | 60 | 25 | 3 | ||
Exp. Kishor find a1 so what value kishor down 1cell(a2)I am not sure I get what you mean,Please can you explain what you need?
I am not sure I get what you mean,Please can you explain what you need?
Book3 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Kishor | raju | Manish | raj | Kishor | 45 | |||
2 | 45 | 60 | 25 | 3 | |||||
Sheet7 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G1 | G1 | =INDEX($A$1:$D$2,2,MATCH(F1,$A$1:$D$1,0)) |
Thanks sir
Book3
A B C D E F G 1 Kishor raju Manish raj Kishor 45 2 45 60 25 3 Sheet7
Cell Formulas Range Formula G1 G1 =INDEX($A$1:$D$2,2,MATCH(F1,$A$1:$D$1,0))