xlookup if found return yes

Keyword Analysis

Keyword	CPC	PCC	Volume	Score	Length of keyword
xlookup if found return yes	1.58	0.1	3715	82	27
xlookup	1.33	0.6	2390	15	7
if	0.49	0.8	2401	48	2
found	1.19	0.1	4087	62	5
return	0.98	0.8	2276	70	6
yes	0.4	0.9	2699	88	3

Keyword	CPC	PCC	Volume	Score
xlookup if found return yes	0.21	0.7	3083	65
excel xlookup return yes if found	0.89	0.3	3072	50
xlookup return yes or no	1.11	0.2	6388	72
vlookup excel if found return yes	1.43	0.5	268	98
xlookup if not found return 0	0.82	0.6	5377	28
vlookup if found return yes	1.41	0.6	9152	93
xlookup return nothing if not found	1.08	0.3	1966	66
vlookup return yes or no if found	1.6	0.1	2903	42
xlookup if not found return text	1.48	0.8	7761	59
xlookup if not found return cell value	1.91	0.5	5360	48
if not found in xlookup	1.1	0.3	3356	87
excel vlookup yes if found	0.95	0.4	8849	82
xlookup return array yes or no	1.95	0.5	190	10
if xlookup returns 0 then	1.88	0.6	6504	42
why is my xlookup returning #n/a	0.57	0.9	2808	21