Question

What type of Excel function searches for a specific value in your data using the
spreadsheet columns and a unique identifier within those columns?

Answer 1

Answer:

VLOOKUP stands for "vertical lookup." In Excel, this means the act of looking up data vertically across a spreadsheet, using the spreadsheet's columns -- and a unique identifier within those columns -- as the basis of your search. When you look up your data, it must be listed vertically wherever that data is located.

mark as brainliest plzzzzz n follow me

Answer 2

Answer:

The answer to the given question:

VLOOKUP

Explanation:

The VLOOKUP function is a native Excel function that allows you to search an entire column.

Columns containing data used in searches must always be on the left. Different parts of the function are separated by characters such as commas or semicolons.

Use VLOOKUP when you need to find something in a table or range row by row. For example, find the price of an auto part by part number or find the employee name based on employee ID.

In its simplest form, the VLOOKUP function says: /TRUE or 0/FALSE ).

the value you are looking for. The value you are looking for must be in the first column of the range of cells specified in the table_array argument.

For example, if the array table spans cells B2:D7, lookup_value must be in column B.

Lookup_value can be a value or a cell reference.

#SPJ3