Finding data from Table 1 with various variables to enter the correct value in table 2

[Taztaztic]

Hello,

I have an issue which is bugging me!

I want to look up the data in Table 1 to enter the correct values in Table 2. What is the easiest way of doing this?

Is there a formula to do this?

Please see below

Can anyone solve this for me?

Thanks

TABLE 1

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​

124756​

Module2​

ANTH0014 - The Anthropology of Kinship and Gender​

6547896​

124756​

Module3​

ANTH0044 - Human Behavioural Ecology​

8754561​

124756​

Module4​

ARCL0030 - Current Issues in Archaeological Theory​

20132​

124756​

Module5​

ARCL0038 - Research and Presentation Skills​

124575​

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​

ANTH0049 - Anthropology of Capitalisms​

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​

​

 

[SanjayGMusafir]

Check this and revert -

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

Cell Formulas
Range	Formula
H4:O8	H4	=XLOOKUP(1,($B$4:$B$42=$G4)*($C$4:$C$42=H$3),$D$4:$D$42)

 

[Fluff]

Another option

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

Cell Formulas
Range	Formula
H3:O7	H3	=FILTER($D$3:$D$100,($B$3:$B$100=$G3)*($C$3:$C$100=H$2),"")