xlookup if found return yes

Keyword Analysis

Keyword	CPC	PCC	Volume	Score	Length of keyword
xlookup if found return yes	1.21	0.8	2614	63	27
xlookup	1.56	0.6	3153	72	7
if	0.97	0.9	6237	42	2
found	1.6	0.1	9212	75	5
return	0.14	0.4	1511	46	6
yes	1.03	0.3	3361	15	3

Keyword	CPC	PCC	Volume	Score
xlookup if found return yes	1.99	0.7	966	85
excel xlookup return yes if found	1.84	0.3	4462	72
xlookup return yes or no	1.25	0.8	7700	23
vlookup excel if found return yes	1.94	0.1	5861	10
xlookup if not found return 0	1.46	0.3	9791	42
vlookup if found return yes	1.06	0.2	8606	46
xlookup return nothing if not found	1.63	0.5	863	73
vlookup return yes or no if found	0.32	0.7	9930	7
xlookup if not found return text	1.43	0.3	8725	51
xlookup if not found return cell value	1.23	0.1	8138	75
if not found in xlookup	1.6	0.4	8043	66
excel vlookup yes if found	0.65	0.5	6361	31
xlookup return array yes or no	1.31	0.4	3212	92
if xlookup returns 0 then	0.65	0.4	4251	42
why is my xlookup returning #n/a	1.04	0.7	4501	32