0
The Match function is used to find the position of a value in a list of. So say you have a list of names, in the cells from A2 to A20, the Match function will search through the list and find which position a particular value is in. Say you have a list of fruits and you are looking for bananas, you could do this:
=MATCH(A2:A20,"Bananas",0)
It can also be used to find a close value if there isn't a perfect match, either the lowest number or text alphabetically above it by specifying -1 where the zero is, or the highest number or text alphabetically below it by specifying 1 where the zero is. That number can be left out altogether, in which case it assumes that you want to use the 1 setting. You also need to have the values in order, either ascending if you are using 1 or descending if you are using -1.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
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 Excel function finds the position of an item in a table?
The MATCH function can find the position of an item in a table.
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 is the step function of Microsoft Excel?
There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.
Which excel function can be used to find an answer located in a vertical table?
VLOOKUP is the name of the function you are looking for. There are other ways of doing it, like using INDEX and MATCH together, which is the way some people prefer to do it.
A formula prewritten by excel is called?
Function
Does the uplookvert function in Excel exist?
There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.
In excel 2013 where are the various function categories stored on the Ribbon?
In Excel Where are the various function categories stored on the Ribbon?
What is the function of percentage in micro-soft Excel?
functions of excel
An If function within an if function in Excel is called what?
A nested if.
Is there any shortcut function to match positive amount with Negative amount in Excel 2007?
=-b7 where b7 is an example cell reference. The result will be the negative of whatever is in b7.
How does the trig function ACOS work in Excel?
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
