103k views
0 votes
Which of the following is NOT a Lookup or Reference function?

1) VLOOKUP
2) INDEX
3) FIND
4) MATCH

User DerZyklop
by
8.1k points

1 Answer

2 votes

Final answer:

The function that is not a Lookup or Reference function is FIND. VLOOKUP, INDEX, and MATCH are used for data lookups, whereas FIND is a text function used to locate substrings within a string.

Step-by-step explanation:

The function that is NOT a Lookup or Reference function among the options provided is FIND. The functions VLOOKUP, INDEX, and MATCH are all used for looking up and referencing data within a spreadsheet in various ways.

VLOOKUP stands for 'Vertical Lookup' and is used to search for a value in the first column of a table and return a value in the same row from a specified column. INDEX retrieves a value at a given position in a range or array. MATCH searches for a specified item in a range of cells, and then returns the relative position of that item.

In contrast, FIND is a text function that locates the position of a substring within a string, and it is not primarily used for looking up or referencing data.

User Yaniv Oliver
by
7.6k points