Lookup and reference functions

HASANY

Not yet implemented

Listed by Microsoft for lists and arrays in cells; no catalogue row yet. How we measure this

No local names are recorded for this entry.

What it does

HASANY(array, values)

HASANY tests whether an array or range contains at least one of the given values, returning TRUE or FALSE.

HASANY(array, values)

Nested levels are searched too.

Try it

Input cells (optional)

Example: {"B2": 3, "B3": 4}. A1 holds the formula. Other cells need values before a formula can read them.

Enter a formula, then calculate.

Runs locally in your browser with OneCalc. Its answer may differ from Excel. Use English function names and commas between arguments.

The OneCalc preview has no answer for this function: see the state above.

Quirks

Microsoft's page does not state its matching rules in detail, and no reading is recorded here.

How to implement

No implementation exists yet. It needs arrays held in a single cell and nested arrays, which DNA Calc's value model does not have, then the search or flattening rule on top. Exact matching rules should be measured in Excel first.

Rust code

This entry has no Rust implementation yet.

No implementation has been published with a Handbook test suite for this function.

Version differences

Microsoft announced it in September 2026 for Insiders on Windows and Mac, with lists and arrays in cells. Its page lists Excel for Microsoft 365 on Windows and Mac. No Excel answers for this function are recorded here, so no comparison between Excel builds exists.

Alternatives

  • HAS and HASALL.
  • COUNTIF or XMATCH on ordinary ranges.

Named variants

No named variants are recorded yet.

Suggest a correction or contribute an implementation · For agents