changing the returned value from xlookup

[lezawang]

Hi
What I want to do, if the employee name is in the list of the training then excel will put Yes, if not, then excel will enter "----". I managed to do the Yes part but not "----". Thanks you very much

Book3
	A	B	C	D	E	F	G	H	I	J
1
2	Employee ID	Employee Name	Attended or not?				List of Employee attended the training
3	769	Mary1	#N/A				Name
4	985	David1	#N/A				Anna1
5	954	Sarah1	#N/A				Li1
6	163	Alex1	#N/A				Jim1
7	588	Anna1	yes				Liz1
8	481	Sam1	yes				Sam1
9	631	Jack1	#N/A				Anna2
10	162	Eric1	#N/A				Li2
11	566	Jim1	yes				Jim2
12	862	Dan1	#N/A				Liz2
13	630	Andy1	#N/A				Sam2
14	1000	Li1	yes				Anna3
15	637	Liz1	yes				Li3
Sheet1 (2)

Cell Formulas
Range	Formula
C3:C15	C3	=IF(XLOOKUP(B3,$G$4:$G$24,$G$4:$G$24)="#N/A","---","yes")

 

[Michael M]

Don't have XLOOKUP, but what about

=IF(ISNUMBER(MATCH(B3,$G$4:$G$24,0)),"YES","---")