XLOOKUP vs MATCH vs STOCKHISTORY
Compact mode

XLOOKUP vs MATCH vs STOCKHISTORY

Table of content

Basic Classification Comparison

Usage Context Comparison

Basic Information Comparison

  • Known For ⭐
    Distinctive characteristic or primary strength of the Excel function
    XLOOKUP
    • Dynamic Array Support
      XLOOKUP is known for Dynamic Array Support.
    MATCH
    • Position Finding
      MATCH is known for Position Finding.
    STOCKHISTORY
    • Stock Data Retrieval
      STOCKHISTORY is known for Stock Data Retrieval.

Facts Comparison

  • Interesting Fact 💡
    Unique or lesser-known information about the Excel function
    XLOOKUP
    • First major update to lookup functions in 20 years
    MATCH
    • Best friend of INDEX
    STOCKHISTORY
    • First native stock data function

  • Sarcastic Fact 🤣
    Humorous or ironic observation about the Excel function
    XLOOKUP
    • Makes VLOOKUP feel like using a flip phone in 2024
    MATCH
    • The function that plays hide and seek
    STOCKHISTORY
    • Like having a time machine for stock prices

Technical Details Comparison

  • Input Data Type 📝
    Types of data that the Excel function accepts as input parameters
    For all*
    XLOOKUP
    • Number
      XLOOKUP accepts Number as input data. Excel functions specifically designed for numerical calculations
    MATCH
    • Number
      MATCH accepts Number as input data. Excel functions specifically designed for numerical calculations
    STOCKHISTORY
    • Date
      STOCKHISTORY accepts Date as input data. Excel functions for working with dates and time values

  • Version Compatibility 💻
    Indicates which Excel versions and platforms the function is compatible with < including Office 365< Excel 2019< 2016< etc.
    For all*
    • Microsoft 365
      Excel functions optimized for the latest Microsoft 365 platform
    XLOOKUP
    • Excel 2019
      XLOOKUP is compatible with Excel 2019 Excel functions that work specifically in Excel 2019 version
    MATCH
    • Excel 2019
      MATCH is compatible with Excel 2019 Excel functions that work specifically in Excel 2019 version
    • Excel 2016
      MATCH is compatible with Excel 2016 Excel functions that work specifically in Excel 2016 version
    • Excel 2013
      MATCH is compatible with Excel 2013 Excel functions that work specifically in Excel 2013 version
    • Excel Online
      MATCH is compatible with Excel Online Excel functions optimized for use in the web-based Excel Online platform

  • Operating System 💾
    Specifies the operating systems where the function can be used < including Windows< macOS< and web platforms
    For all*
    • Windows
      Excel functions optimized for Windows operating system
    • MacOS
      Excel functions optimized for MacOS users
    XLOOKUP
    • Excel Online
      XLOOKUP runs on Excel Online Excel functions available in the online version of Excel
    • Web Excel
      XLOOKUP runs on Web Excel Excel functions available in web-based versions
    MATCH
    • Web Excel
      MATCH runs on Web Excel Excel functions available in web-based versions
    STOCKHISTORY
    • Excel Online
      STOCKHISTORY runs on Excel Online Excel functions available in the online version of Excel

  • Required Arguments Count 🔢
    Number of mandatory arguments needed for the function to work properly
    XLOOKUP
    MATCH
    STOCKHISTORY

  • Required Arguments Type 📊
    The data types accepted as valid input arguments for the function
    For all*
    • Text
      Excel functions specialized in text string manipulation and processing
    XLOOKUP
    • Range
      XLOOKUP accepts Range as input types Excel functions that operate on cell ranges for calculations
    • Number
      XLOOKUP accepts Number as input types Excel functions that perform calculations specifically with numerical inputs
    MATCH
    • Range
      MATCH accepts Range as input types Excel functions that operate on cell ranges for calculations
    • Number
      MATCH accepts Number as input types Excel functions that perform calculations specifically with numerical inputs
    • Array
      MATCH accepts Array as input types Excel functions that specifically work with array inputs for calculations
    STOCKHISTORY
    • Date
      STOCKHISTORY accepts Date as input types Excel functions specialized in processing date and time calculations

Evaluation Comparison

Ratings Comparison

Alternatives to XLOOKUP
SUMIFS
Known for Multiple Condition Sum
VLOOKUP
Known for Vertical Data Search
🔢 needs fewer arguments than MATCH
📈 is more versatile than MATCH
INDEX
Known for Advanced Data Retrieval
📈 is more versatile than MATCH
⚙ performs better than MATCH
⭐ is rated higher than MATCH
LOOKUP
Known for Simple Vertical And Horizontal Lookups
INDEX_MATCH
Known for Two-Way Lookup Power
📈 is more versatile than MATCH
⚙ performs better than MATCH
🛠 is more reliable than MATCH
⭐ is rated higher than MATCH
COUNTIF
Known for Counting With Conditions
📊 is easier to use than MATCH
⚙ performs better than MATCH
HLOOKUP
Known for Horizontal Data Lookup
🔢 needs fewer arguments than MATCH
SUM
Known for Basic Arithmetic Calculations
📊 is easier to use than MATCH
⚙ performs better than MATCH
🛠 is more reliable than MATCH
⭐ is rated higher than MATCH
SUBSTITUTE
Known for Replace Specific Text
📊 is easier to use than MATCH
⚙ performs better than MATCH
🛠 is more reliable than MATCH
⭐ is rated higher than MATCH
AVERAGEIFS
Known for Multiple Criteria Based Average