Need help with Text Match in Google sheets

[Ravi0304]

I am working on a grade sheet where in 2 teachers grade a given student on 2 different sheets. I have to collate the data basis the grade. Example: If student gets A from both teachers, my master sheet should show both gave A and return value as A but if one gives a A and one gives B it should return a text that says "Review". Please help me.

 

[Sufiyan97]

Hello & Welcome to Mr. Excel

Try

Master

Book2
	A	B
1	Student Name	Grade
2	A	A
3	B	Review
4	C	B
5	D	Review
6
7
8
9
Master

Cell Formulas
Range	Formula
B2:B5	B2	=IF(VLOOKUP(A2,Tacher1!A:B,2,0)=VLOOKUP(A2,Tacher2!A:B,2,0),VLOOKUP(A2,Tacher1!A:B,2,0),"Review")

Teacher 1

Book2
	A	B
1	Student Name	Grade
2	A	A
3	B	B
4	C	B
5	D	A
6
7
8
9
Tacher1

Teacher 2

Book2
	A	B
1	Student Name	Grade
2	A	A
3	B	A
4	C	B
5	D	B
6
7
8
9
Tacher2