XLOOKUP

Unsupported (not recognized)

Category: Lookup and reference · Last tested 2026-07-04

Support matrix

Engine	Documented	Live-tested	Verdict
Excel	Yes	Not yet	n/a
Google Sheets	Yes	Not yet	n/a
LibreOffice Calc	No	Yes (24.2.7.2, 2026-07-04)	Unsupported (not recognized)

=XLOOKUP("b",A1:A3,B1:B3) on LibreOffice Calc returned #NAME?, but the documented/expected result is 2. MISMATCH vs expected: expected 2, got '#NAME?'
=XLOOKUP("z",A1:A3,B1:B3) on LibreOffice Calc returned #NAME?, but the documented/expected result is #N/A. MISMATCH vs expected: expected '#N/A', got '#NAME?'
=XLOOKUP("z",A1:A3,B1:B3,"missing") on LibreOffice Calc returned #NAME?, but the documented/expected result is missing. MISMATCH vs expected: expected 'missing', got '#NAME?'
=XLOOKUP(2.5,A1:A4,B1:B4,"none",-1) on LibreOffice Calc returned #NAME?, but the documented/expected result is 20. 2.5 has no exact match; next-smaller is 2 -> 20; MISMATCH vs expected: expected 20, got '#NAME?'
=XLOOKUP("x",A1:A4,B1:B4,"none",0,-1) on LibreOffice Calc returned #NAME?, but the documented/expected result is 3. Two rows match 'x' (1 and 3); reverse search returns the later one; MISMATCH vs expected: expected 3, got '#NAME?'
=XLOOKUP("a",A1:A1,B1:B1) on LibreOffice Calc returned #NAME?, but the documented/expected result is #N/A. A1 and B1 are blank; lookup value 'a' is not found; MISMATCH vs expected: expected '#N/A', got '#NAME?'

Formula	Description	Result	Expected	Verdict
=XLOOKUP("b",A1:A3,B1:B3)	Basic exact-match lookup returns the corresponding value	#NAME?	2	Mismatch
=XLOOKUP("z",A1:A3,B1:B3)	No if_not_found arg and no match -> #N/A	#NAME?	#N/A	Mismatch
=XLOOKUP("z",A1:A3,B1:B3,"missing")	Custom if_not_found value is returned when no match	#NAME?	missing	Mismatch
=XLOOKUP(2.5,A1:A4,B1:B4,"none",-1)	match_mode -1 (exact or next smaller item) with no exact match	#NAME?	20 2.5 has no exact match; next-smaller is 2 -> 20	Mismatch
=XLOOKUP("x",A1:A4,B1:B4,"none",0,-1)	search_mode -1 finds the LAST occurrence of a duplicated key	#NAME?	3 Two rows match 'x' (1 and 3); reverse search returns the later one	Mismatch
=XLOOKUP("a",A1:A1,B1:B1)	Degenerate 1-cell lookup/return arrays where the cell is blank	#NAME?	#N/A A1 and B1 are blank; lookup value 'a' is not found	Mismatch