Find value other sheet

[pmeghnathi]

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

 

[Momentman]

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 am not sure I get what you mean,Please can you explain what you need?

 

[pmeghnathi]

I am not sure I get what you mean,Please can you explain what you need?

Exp. Kishor find a1 so what value kishor down 1cell(a2)

 

[Momentman]

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))

 

[pmeghnathi]

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