excel match and index function

excel match function returns (gives) the row number in which the desired value lies.
the inputs required are:
1) the cell no of the value (you can just write the value in any cell in place of finding in the database)
2) the column in which it is expected to lie
3) write FALSE as true will be covered automatically.
********************************************************************
excel index function returns (gives) the value of the cell.
the inputs required are:
1) the whole array(range, that is all area including rows and columns) in which the value is expected
2) the column number
3) the row number
********************************************************************
So in effect these two functions can be jointly used to get any other related value which lies in the same row as the value itself.
First find out the row number of the value using match function
next, use index to get the related value as you now know the row number, column number and the array .
Note: this method works because when we prepare database, the columns are given for different items, so it is not difficult to find out that the related value will lie in which column.
The main problem lies in getting the row numbers which contains the different values which can be solved by using match function.