Forumla for multiple matches-

[rawr19911]

trying to think of a formula i was playing around with vlookup and ifs but cant figure out how to do this wanting to automate a way to state if a user took a class or did not take a class on transcripts

 

[ExceLoki]

try this
-----------------------

Book1
	A	B	C	D	E	F	G	H
1	user	type	title		did user take class	title 1	title 2	title 3
2	sample name 1	online	title 1		sample name 1	yes	yes	no
3	sample name 2	online	title 1		sample name 2	yes	yes	no
4					sample name 3	no	no	yes
5	sample name 1	online	title 2
6	sample name 2	curriculum	title 2
7	sample name 3	online	title 3
Sheet1

Cell Formulas
Range	Formula
F2:H4	F2	=IFERROR(IF(INDEX($B$1:$B$7,MATCH(1,($E2=$A$1:$A$7)*(F$1=$C$1:$C$7),0))<>"","yes"),"no")

 

[BigBeachBananas]

--

 

[rawr19911]

try this
-----------------------

Book1
	A	B	C	D	E	F	G	H
1	user	type	title		did user take class	title 1	title 2	title 3
2	sample name 1	online	title 1		sample name 1	yes	yes	no
3	sample name 2	online	title 1		sample name 2	yes	yes	no
4					sample name 3	no	no	yes
5	sample name 1	online	title 2
6	sample name 2	curriculum	title 2
7	sample name 3	online	title 3
Sheet1

Cell Formulas
Range	Formula
F2:H4	F2	=IFERROR(IF(INDEX($B$1:$B$7,MATCH(1,($E2=$A$1:$A$7)*(F$1=$C$1:$C$7),0))<>"","yes"),"no")

this works i just gota understand it now to use it for what i need thanks !

 

[ExceLoki]

1. the index/match is looking to return the type for each user based on the title.
2. the next part is looking to see if 1 returns a value then it shows yes
3. if 1 returns an error because there is not a match for the user & title, then it returns no