Checking data between Table 1 and Table 2.......what is the easiest way?

[Taztaztic]

Hello,

I need to use Table 1 to check the values that have been entered in Table 2 to make sure the values have been correctly entered.

What is the easiest way of doing this? Is there a formula to do this?

Please note, I have purposely entered some incorrect values in Table 2 to check if the method or formula used will work.

Please see below:

TABLE 1

TABLE 1

TABLE 1

TABLE 2

TABLE 2

TABLE 2

TABLE 2

TABLE 2

TABLE 2

TABLE 2

TABLE 2

TABLE 2

ID​

Module Number​

Module​

ID​

Module1​

Module2​

Module3​

Module4​

Module5​

Module6​

Module7​

Module8​

124756​

Module1​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

124756​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

ANTH0014 - The Anthropology of Kinship and Gender​

ANTH0044 - Human Behavioural Ecology​

ARCL0030 - Current Issues in Archaeological Theory​

ARCL0038 - Research and Presentation Skills​

ARCL0054 - The Aztecs and the Conquest of Mexico​

ARCL0208 - The Archaeology of London​

ANTH0044 - Human Behavioural Ecology​

124756​

Module2​

ANTH0014 - The Anthropology of Kinship and Gender​

6547896​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

ANTH0062 - Anthropology of Cultural Heritage and Museum Anthropology​

ANTH0064 - Anthropology of the Built Environment​

ARCL0030 - Current Issues in Archaeological Theory​

ARCL0038 - Research and Presentation Skills​

ARCL0083 - The Early Islamic World​

ARCL0208 - The Archaeology of London​

124756​

Module3​

ANTH0044 - Human Behavioural Ecology​

8754561​

ANTH0073 - Digital Infrastructure: Materiality, Information and Politics​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

ANTH0079 - Aspects of Applied Medical Anthropology​

ARCL0030 - Current Issues in Archaeological Theory​

ARCL0036 - Archaeological Illustration and Imaging​

ARCL0038 - Research and Presentation Skills​

ARCL0041 - Organic Materials in Archaeology​

LCSP0002 - Spanish Level 1​

124756​

Module4​

ARCL0030 - Current Issues in Archaeological Theory​

20132​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

ANTH0014 - The Anthropology of Kinship and Gender​

ANTH0136 - The Anthropology of Violent Aftermaths​

ARCL0027 - Archaeological Surveying​

ARCL0030 - Current Issues in Archaeological Theory​

ARCL0038 - Research and Presentation Skills​

ARCL0049 - The Archaeology of Human Remains​

LCBS0001 - British Sign Language Level 1​

124756​

Module5​

ARCL0038 - Research and Presentation Skills​

124575​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

ANTH0049 - Anthropology of Capitalisms​

ARCL0030 - Current Issues in Archaeological Theory​

ARCL0038 - Research and Presentation Skills​

ARCL0083 - The Early Islamic World​

ANTH0059 - Anthropology of Religion​

POLS0027 - Human Rights and World Politics​

124756​

Module6​

ARCL0054 - The Aztecs and the Conquest of Mexico​

124756​

Module7​

ARCL0208 - The Archaeology of London​

124756​

Module8​

LCSP0002 - Spanish Level 1​

6547896​

Module1​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

6547896​

Module2​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

6547896​

Module3​

ANTH0062 - Anthropology of Cultural Heritage and Museum Anthropology​

6547896​

Module4​

ANTH0064 - Anthropology of the Built Environment​

6547896​

Module5​

ARCL0030 - Current Issues in Archaeological Theory​

6547896​

Module6​

ARCL0038 - Research and Presentation Skills​

6547896​

Module7​

ARCL0083 - The Early Islamic World​

6547896​

Module8​

ARCL0208 - The Archaeology of London​

8754561​

Module1​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

8754561​

Module2​

ANTH0073 - Digital Infrastructure: Materiality, Information and Politics​

8754561​

Module3​

ANTH0079 - Aspects of Applied Medical Anthropology​

8754561​

Module4​

ARCL0030 - Current Issues in Archaeological Theory​

8754561​

Module5​

ARCL0036 - Archaeological Illustration and Imaging​

8754561​

Module6​

ARCL0038 - Research and Presentation Skills​

8754561​

Module7​

ARCL0041 - Organic Materials in Archaeology​

8754561​

Module8​

LCSP0002 - Spanish Level 1​

20132​

Module1​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

20132​

Module2​

ANTH0014 - The Anthropology of Kinship and Gender​

20132​

Module3​

ANTH0136 - The Anthropology of Violent Aftermaths​

20132​

Module4​

ARCL0027 - Archaeological Surveying​

20132​

Module5​

ARCL0030 - Current Issues in Archaeological Theory​

20132​

Module6​

ARCL0038 - Research and Presentation Skills​

20132​

Module7​

ARCL0049 - The Archaeology of Human Remains​

20132​

Module8​

LCBS0001 - British Sign Language Level 1​

124575​

Module1​

ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture​

124575​

Module2​

ANTH0049 - Anthropology of Capitalisms​

124575​

Module3​

ANTH0059 - Anthropology of Religion​

124575​

Module4​

ARCL0030 - Current Issues in Archaeological Theory​

124575​

Module5​

ARCL0038 - Research and Presentation Skills​

124575​

Module6​

ARCL0083 - The Early Islamic World​

124575​

Module7​

POLS0027 - Human Rights and World Politics​

Thanks

 

[awoohaw]

try this:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	TABLE 1	TABLE 1	TABLE 1				TABLE 2	TABLE 2	TABLE 2	TABLE 2	TABLE 2	TABLE 2	TABLE 2	TABLE 2	TABLE 2
2	ID	Module Number	Module				ID	Module1	Module2	Module3	Module4	Module5	Module6	Module7	Module8
3	124756	Module1	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	TRUE			124756	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	ANTH0014 - The Anthropology of Kinship and Gender	ANTH0044 - Human Behavioural Ecology	ARCL0030 - Current Issues in Archaeological Theory	ARCL0038 - Research and Presentation Skills	ARCL0054 - The Aztecs and the Conquest of Mexico	ARCL0208 - The Archaeology of London	ANTH0044 - Human Behavioural Ecology
4	124756	Module2	ANTH0014 - The Anthropology of Kinship and Gender	TRUE			6547896	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	ANTH0062 - Anthropology of Cultural Heritage and Museum Anthropology	ANTH0064 - Anthropology of the Built Environment	ARCL0030 - Current Issues in Archaeological Theory	ARCL0038 - Research and Presentation Skills	ARCL0083 - The Early Islamic World	ARCL0208 - The Archaeology of London
5	124756	Module3	ANTH0044 - Human Behavioural Ecology	TRUE			8754561	ANTH0073 - Digital Infrastructure: Materiality, Information and Politics	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	ANTH0079 - Aspects of Applied Medical Anthropology	ARCL0030 - Current Issues in Archaeological Theory	ARCL0036 - Archaeological Illustration and Imaging	ARCL0038 - Research and Presentation Skills	ARCL0041 - Organic Materials in Archaeology	LCSP0002 - Spanish Level 1
6	124756	Module4	ARCL0030 - Current Issues in Archaeological Theory	TRUE			20132	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	ANTH0014 - The Anthropology of Kinship and Gender	ANTH0136 - The Anthropology of Violent Aftermaths	ARCL0027 - Archaeological Surveying	ARCL0030 - Current Issues in Archaeological Theory	ARCL0038 - Research and Presentation Skills	ARCL0049 - The Archaeology of Human Remains	LCBS0001 - British Sign Language Level 1
7	124756	Module5	ARCL0038 - Research and Presentation Skills	TRUE			124575	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	ANTH0049 - Anthropology of Capitalisms	ARCL0030 - Current Issues in Archaeological Theory	ARCL0038 - Research and Presentation Skills	ARCL0083 - The Early Islamic World	ANTH0059 - Anthropology of Religion	POLS0027 - Human Rights and World Politics
8	124756	Module6	ARCL0054 - The Aztecs and the Conquest of Mexico	TRUE
9	124756	Module7	ARCL0208 - The Archaeology of London	TRUE
10	124756	Module8	LCSP0002 - Spanish Level 1	FALSE
11	6547896	Module1	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	TRUE
12	6547896	Module2	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	TRUE
13	6547896	Module3	ANTH0062 - Anthropology of Cultural Heritage and Museum Anthropology	TRUE
14	6547896	Module4	ANTH0064 - Anthropology of the Built Environment	TRUE
15	6547896	Module5	ARCL0030 - Current Issues in Archaeological Theory	TRUE
16	6547896	Module6	ARCL0038 - Research and Presentation Skills	TRUE
17	6547896	Module7	ARCL0083 - The Early Islamic World	TRUE
18	6547896	Module8	ARCL0208 - The Archaeology of London	TRUE
19	8754561	Module1	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	FALSE
20	8754561	Module2	ANTH0073 - Digital Infrastructure: Materiality, Information and Politics	FALSE
21	8754561	Module3	ANTH0079 - Aspects of Applied Medical Anthropology	TRUE
22	8754561	Module4	ARCL0030 - Current Issues in Archaeological Theory	TRUE
23	8754561	Module5	ARCL0036 - Archaeological Illustration and Imaging	TRUE
24	8754561	Module6	ARCL0038 - Research and Presentation Skills	TRUE
25	8754561	Module7	ARCL0041 - Organic Materials in Archaeology	TRUE
26	8754561	Module8	LCSP0002 - Spanish Level 1	TRUE
27	20132	Module1	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	TRUE
28	20132	Module2	ANTH0014 - The Anthropology of Kinship and Gender	TRUE
29	20132	Module3	ANTH0136 - The Anthropology of Violent Aftermaths	TRUE
30	20132	Module4	ARCL0027 - Archaeological Surveying	TRUE
31	20132	Module5	ARCL0030 - Current Issues in Archaeological Theory	TRUE
32	20132	Module6	ARCL0038 - Research and Presentation Skills	TRUE
33	20132	Module7	ARCL0049 - The Archaeology of Human Remains	TRUE
34	20132	Module8	LCBS0001 - British Sign Language Level 1	TRUE
35	124575	Module1	ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture	TRUE
36	124575	Module2	ANTH0049 - Anthropology of Capitalisms	TRUE
37	124575	Module3	ANTH0059 - Anthropology of Religion	FALSE
38	124575	Module4	ARCL0030 - Current Issues in Archaeological Theory	FALSE
39	124575	Module5	ARCL0038 - Research and Presentation Skills	FALSE
40	124575	Module6	ARCL0083 - The Early Islamic World	FALSE
41	124575	Module7	POLS0027 - Human Rights and World Politics	TRUE
Sheet1

Cell Formulas
Range	Formula
D3:D41	D3	=INDEX($H$3:$O$7,MATCH($A3,$G$3:$G$7,0),MATCH($B3,$H$2:$O$2,0))=C3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:O41	Expression	=$D3=FALSE	text	NO