why is xlookup returning a 0

Keyword Analysis

Keyword	CPC	PCC	Volume	Score	Length of keyword
why is xlookup returning a 0	0.46	0.2	1550	62	28
why	1.46	0.8	4478	76	3
is	0.5	0.5	975	75	2
xlookup	1.88	0.1	6297	66	7
returning	0.49	1	1803	5	9
a	1.69	0.3	9740	94	1

Keyword	CPC	PCC	Volume	Score
why is xlookup returning a 0	0.92	0.8	5265	68
why is my xlookup returning a 0	0.83	0.3	9149	60
why is my xlookup function returning 0	1.17	0.5	3325	73
why is my xlookup returning #n/a	1.18	0.9	1979	37
why is vlookup returning a 0	0.51	0.3	4616	2
xlookup don't return 0	1.75	0.9	3823	65
prevent xlookup from returning 0	0.84	0.3	7567	69
excel xlookup returning 0	1.17	0.2	4788	23
xlookup returning 0 instead of text	1.52	0.1	9764	86
excel xlookup returns 0	0.63	0.9	8325	5
why xlookup returns n/a	1	0.7	3199	94
xlookup if not found return 0	1.36	0.6	9826	45
xlookup not returning values	0.64	0.6	9594	36
why vlookup returns 0	1.29	0.6	652	30