XLOOKUP – Excel Function
What it does: The XLOOKUP() Function allows you to look up and return values in corresponding columns or rows (!!). I have an
INDEX – Excel Function
What it does: THE INDEX() Function returns a value based on the array of values you select and the row and column within that
HYPERLINK – Excel Function
What it does: The Hyperlink() function links the cell to a local location (another point in the spreadsheet, another tab,
MATCH – Excel Function
What it Does – Locate the position (often the row number) of an item in an array. Arguments: MATCH(lookup_value,