Friday, April 3, 2015

Getting a Value Giving Column and Row on Excel

Many times it's interesting to see how business requires you to use functions from Excel that you don't even know they exist. In this post I have the following mission: I want to know the value of a cell when I write the column and row, consider that column and row can have any identification.

To get the value from a table you must use 2 functions: Match and Index, Match function gives you the position of a given value in a range, therefore it's necessary to first get the position of the column and the row.

Once you have both positions use them into Index function that is going to give you the value located in the position you put related to a given matrix.

No comments:

Post a Comment