Index function
Index function gives us cell value which we instruct excel to find in table array of particular row and particular column.
=index( array, row no, column no)
array is where we want excel to look in
In my formula i have given array as B2:G8 which are all records in table
i wanted cell value reliance petroleum so i gave row no 3 & column no1
That's it
Comments
Post a Comment