Excel - INDEX function
Unlike most other Excel functions which deal with a single number, a row or a column, INDEX function deals with a data table. It answers questions such as "what is the number at row 3 and column 4?"
In the data range highlighted yellow above, what is the number at row 3 and column 2? Remember we only talk about the data range, not including header row. So the data on row 3 is carrot, not banana.
The formula is:
=INDEX(A2:B5,3,2)
It returns 1.5, which is the price of carrot.
Comments
Post a Comment