SVERWEIS (EN)

Tool

Excel function for searching and returning values from tables

Architecture

flowchart TD     A[Search_Criteria] --> B[SVERWEIS-Function]     B --> C[Search in first column of matrix]     C --> D{Value found?}     D -->|Yes| E[Return value from specified column]     D -->|No| F[#NV Error]     E --> G[Result in cell]

In Context

  • Typically used together with IFERROR, MATCH and INDEX
  • Related to: MATCH, INDEX, HVERWEIS, XVERWEIS
  • Example use: Retrieve employee data from a large table using the employee number
Quelle: AI Generated