The function is best used to look up and retrieve data from a specific row in a table is LOOKUP.
The use of the LOOKUP functions is often used when a person need to look in a single row or column and obtain a value from a position.
Therefore, The function is best used to look up and retrieve data from a specific row in a table is LOOKUP.
Learn more about function from
https://brainly.com/question/25638609
#SPJ1