Can I Spreadsheet?
← All functions

LOOKUP

Supported, behaves as documented

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

Support matrix

EngineDocumentedLive-testedVerdict
Excel Yes Not yet n/a
Google Sheets Yes Not yet n/a
LibreOffice Calc Yes Yes (24.2.7.2, 2026-07-04) Supported, behaves as documented

Executed test cases

LibreOffice Calc 24.2.7.2 (tested 2026-07-04)

FormulaDescriptionResultExpectedVerdict
=LOOKUP(3,A1:A5,B1:B5) Vector form exact match against an ascending-sorted lookup_vector 30 30
https://support.microsoft.com/en-us/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb -- lookup_vector must be in ascending order for LOOKUP to work correctly; this vector is sorted		 Matched
=LOOKUP(3.5,A1:A5,B1:B5) No exact match; LOOKUP uses the largest lookup_vector value that is <= lookup_value 30 30
3.5 has no exact match; largest value <=3.5 is 3 -> paired result 30		 Matched
=LOOKUP(0,A1:A5,B1:B5) lookup_value smaller than every entry in lookup_vector -> #N/A #N/A #N/A Matched
=LOOKUP(2,A1:B3) Array form (single 2-D argument, no separate result_vector): since A1:B3 has more rows than columns, LOOKUP searches the FIRST column and returns from the LAST column 200 200
Per Microsoft docs' array-form rule (searches first row/col depending on which is longer): match on A2=2 returns paired last-column value 200		 Matched

Docs & syntax