The Excel function for searching and retrieving values is VLOOKUP.
VLOOKUP function is used in Excel to search for a specific value in a range of cells and retrieve the corresponding value in the same position of another column.
https://brainly.com/question/34790772