Tag: #formula
3 articles
-
MATCH vs XMATCH — The Lookup Functions That Return a Position, and When to Use Each
MATCH and XMATCH both return "where a value sits (its position)" rather than the value itself. They differ in their default match mode, reverse search, and wildcard handling. This guide sorts out the differences with examples, shows how to combine them with INDEX to pull values more flexibly than VLOOKUP, and demonstrates how ReoGrid (supported in V4.5) runs the same formulas inside a WinForms / WPF app — no Office required.
-
VLOOKUP vs HLOOKUP vs XLOOKUP — Knowing the Difference and Using Them in a C# Spreadsheet
VLOOKUP, HLOOKUP, and XLOOKUP look alike, but they differ in which direction they search, how you point at the value to return, and what happens when nothing is found. This guide sorts out the differences with tables and examples, shows why XLOOKUP fixes VLOOKUP's weak spots, and demonstrates how ReoGrid (supported in V4.5) runs the very same formulas inside a WinForms / WPF app — no Office required.
-
Announcing ReoGrid 4.5 — 47 Excel-Compatible Functions and Point-Mode Formula Editing
ReoGrid 4.5 adds 47 Excel-compatible formula functions, point-mode formula editing, XLSX outline (grouping) import/export, and major XLSX load-time performance and memory improvements.