Lookup and Reference functions

Lookup and Reference functions search for values within ranges and return data based on their position, and they build and manipulate references to cells and arrays — letting you find matches, retrieve related values and navigate around a worksheet.