N
Nadine
Can someone please explain the Index, Match formula to me? It is used in a
spreadsheet and I need to understand it. Thank.
spreadsheet and I need to understand it. Thank.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Glenn
Nadine said:Can someone please explain the Index, Match formula to me? It is used in a
spreadsheet and I need to understand it. Thank.
http://www.contextures.com/xlFunctions03.html
P
Paul C
There are many different potential ways to write a formula using Index and
Match.
If you post the specific formula, it may help someone explain the usage
further.
Very briefly the syntax for Index is (Array,Row num, [Col num])
Thus Index(A1:A5,3) would return the value in A3 (the third postion in the
array)
If data cannot be sorted to allow a Lookup,Vlookup or Hloolup you may use a
Match function to get a position
A B
1 Apples 7
2 Pears 5
3 Grapes 3
4 Oranges 4
5 Pinapples 2
The function Index(B1:B5,Match("Pears",A1:A5,0)) would retun the value 5
Match ("Pears",A1:A5,0) finds the position of the first item in A1:A5 that
exactly equals (signified by the ,0) "Pears" in this case 2
The function is then reduced to Index(B1:B5,2) which returns the second item
in the array B1:B5 which is the number 5
Match.
If you post the specific formula, it may help someone explain the usage
further.
Very briefly the syntax for Index is (Array,Row num, [Col num])
Thus Index(A1:A5,3) would return the value in A3 (the third postion in the
array)
If data cannot be sorted to allow a Lookup,Vlookup or Hloolup you may use a
Match function to get a position
A B
1 Apples 7
2 Pears 5
3 Grapes 3
4 Oranges 4
5 Pinapples 2
The function Index(B1:B5,Match("Pears",A1:A5,0)) would retun the value 5
Match ("Pears",A1:A5,0) finds the position of the first item in A1:A5 that
exactly equals (signified by the ,0) "Pears" in this case 2
The function is then reduced to Index(B1:B5,2) which returns the second item
in the array B1:B5 which is the number 5
E
Eduardo
Hi Nadine,
Take a look to Debra web, she has an excellent explanation and examples
http://www.contextures.com/xlFunctions03.html
Take a look to Debra web, she has an excellent explanation and examples
http://www.contextures.com/xlFunctions03.html