In support of this post
https://excelfox.com/forum/showthrea...5230#post15230

_____ Workbook: Test Paper.xlsb ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
1
TEST-1
2
 Name of the Student : Rizwana
3
 Reg. No. : 256
4
 Class X
Worksheet: Test

If the value of D3 and D4 of Test Sheet is matches with column C & D of Result sheet then, display a message "You are already submitted the test paper and you have secured (D3 and D4 of Test sheet match with column E of Result Sheet) marks".

_____ Workbook: Test Paper.xlsb ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
1
TEST-1 RESULT ANALYSIS
2
Sl. No.
Name of the Student
Reg. No.
Class
Obtained Marks
3
01
 Rukhsar banu
256
X
2
4
02
 Abdulkhadar
123
X
3
5
03
 Rizwana
256
X
4
6
04
 Rizwana
256
X
4
7
05
 Rizwana
256
X
4
Worksheet: Result








15283