Viewing 1 post (of 1 total)
  • Author
    Posts
  • #7479
    Bishow Budha Magar
    Participant

    HI,
    LOOKUP: Searches for a value in the first column of a table and returns a value in the same row from a specified column.
    XLOOKUP: More flexible than VLOOKUP; searches a range or array for a match and returns a corresponding value from another range or array.
    MATCH: Searches for a value in a range and returns the relative position of the item.
    INDEX: Returns the value of a cell in a specified row and column within a range. Often used with MATCH to create a powerful lookup formula.
    In essence:

    VLOOKUP and XLOOKUP are used for finding specific data.
    MATCH provides the position of the data.
    INDEX retrieves data based on position, and can be combined with MATCH for dynamic lookups.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.