answersLogoWhite

0

The Index function finds the value in a list or table at the position given. So if you have a list or a table or even a series of tables, you can specify a position in it and it will return the value at that position. So if you have a list of values from cell A2 to A20, and wanted to find what was in the third cell, you would type the function like this:

=INDEX(A2:A20,3)

IF you have a table, you would use a row and a column position, in the 4th row and 3rd column in a table from A2 to D20, you would do it like this:

=INDEX(A2:D20,4,3)

You can even have several tables and specify which one to search in. You can specify the ranges inside brackets, then specify a row, column and which area to choose from:

=INDEX((A2:D20,C29:H40),4,3,2)

The Match function is used to find the position of a value in a list of values. So if you have a list of cities, including New York in the cells from A2 to A20, the Match function will search through the list and find which position it is in.

=MATCH(A2:A20,"New York",0)

It can also be used to find a close value if there isn't a perfect match, either the lowest number above it by specifying -1 where the zero is, or the highest number 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.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

Is a look up used in Excel?

Yes. There are 3 main functions for doing lookups. They are LOOKUP, VLOOKUP and HLOOKUP. You can also use a combination of the MATCH and INDEX functions to achieve a lookup.


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.


What function can be used in Excel to find info in rows based on values in a table data?

There are a number of functions that could be used to achieve that. They are all categorised as lookup functions. Included in them would be ones like VLOOKUP, HLOOKUP, LOOKUP, INDEX and MATCH. You could also use the Advanced Filter facility.


Can you use Sum Function in school?

If you use Excel in school, then, yes, you can use the SUM function.


To add numeric enteries quick in excel use the function?

Use the Sum function.


How do you write a formula in Excel for if a field has a specific value then go to this field and find said value and return data from corresponding field?

Your question is a bit unclear. However, you may need to use the VLOOKUP function or the INDEX and MATCH functions. Check up these functions as they may provide what you need to do your task.


How do you use the all function in Excel?

you can get help in the Microsoft excel itself by pressing F1 key.


What is quartile Excel function?

There is no function to create a quartile in Excel. A quartile is a 25% division of a statistical collection of data. You can use Excel to create a chart to let you observe the quartiles of the data.


Which function can be used to check whether the value is numeric or not?

In Excel you can use the ISNUMBER() function.


Which Excel function would you use when you want to determine a monthly loan payment?

The PMT function.


How do you do standard deviation on Microsoft Excel?

Use the STDEV() function.


What does Excel use to separate multiple arguments in a function?

Commas are used to separate arguments in Excel functions.