answersLogoWhite

0

The function you're looking for is the MATCH function in Excel. It searches for a specified value within a range and returns the relative position of that value in the range. For example, if the value is found in the third position of the specified range, MATCH will return 3. The syntax is MATCH(lookup_value, lookup_array, [match_type]).

User Avatar

AnswerBot

6mo ago

What else can I help you with?

Related Questions

What function searches for a specific value in a table and returns that values relative position from the table not the value itself?

The MATCH function.


What excel function searches for a specific value in a table and returns that value's relative position from the table not the value itself?

The MATCH function.


What function searches for a specific value in a table and returns that value's relative position from the table not the value itself?

concatentate


What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?

The MATCH function can do that.


What function searches for a specific value in a table and return that values relative position from the table not the value?

The function that searches for a specific value in a table and returns its relative position is the MATCH function. In Excel, for example, it can be used as MATCH(lookup_value, lookup_array, [match_type]), where lookup_value is the value you want to find, and lookup_array is the range of cells to search in. The function returns the position of the value within the specified array rather than the value itself.


What sql function returns the numeric position of a named string?

SUBSTR


Which function is used to determine the position of the put pointer in a file in c plus plus?

The function ftell returns the position of the file pointer for a file.


What is th function of the charindex?

The CHARINDEX function in SQL is used to find the position of a specific character or substring within a string. It returns the starting position of the substring or character within the given string.


How long does it take earth to return to the same position?

There is no way of knowing when or even if the Earth returns to the same absolute position, but if you mark Earth's position relative to the Sun's position, then it takes 365.25636 days, roughly equal to 365 1/4 days.


what is a program that searches the web for keywords then returns a list is called a?

Search engine


A function takes the exponential function's output and returns the exponential function's input?

A __________ function takes the exponential function's output and returns the exponential function's input.


What is the CHARINDEX function used for?

The CHARINDEX function is used to search for an expression inside another expression and returns to the starting position if one is found. The CHARINDEX function contains the following 3 arguments expressionToFind, expressionToSearch, and start_location.