CONCAT vs IFS vs VLOOKUP

Basic Classification Comparison

• Function Category 📊

  Primary classification of the Excel function based on its main purpose and usage domain, helps users quickly identify function types

  CONCAT

  • Text

    CONCAT belongs to the Text category. Excel functions for manipulating and analyzing text data

  IFS

  • Logical

    IFS belongs to the Logical category. Excel functions for performing logical operations and decision making  Click to see all.

  VLOOKUP

  • Lookup & Reference

    VLOOKUP belongs to the Lookup & Reference category. Excel functions for searching and referencing data across spreadsheets

• Operation Type 🔧

  Fundamental type of operation or action that the Excel function performs on its inputs

  CONCAT

  • Manipulation

    CONCAT performs Manipulation operations. Functions that modify and transform data in different ways

  IFS

  • Comparison

    IFS performs Comparison operations. Excel functions for comparing values and data  Click to see all.

  VLOOKUP

  • Retrieval

    VLOOKUP performs Retrieval operations. Functions specialized in fetching data from various sources