How to choose the row based on a given point?

Hello All,

I have an excel sheet with me containing 70 rows and about a 100 columns.

I have a user input command in order to choose which point he wants to use. Say this point is in 'row 14' and 'column 4'.

Now I want to choose another point from 'row 14'.

Is there a code or command with which this can be done easily?

Thank You.

[Azzi Abdelmalek]

A(70,14) is the chosen point, what is your problem?

[Prakash]

The problem is as follows:

The user says he inputs the value '2.4' which is somewhere in the excel table. Now this value will correspond to a certain row which the user is unaware of. In this same row, there is another value in another column which the user need to use. I want to get this value.

eg: He inputs the vehicle speed of '2100 rpm'. On the row where this value is he needs to obtain the 'power' for use. How can Matlab, based on only '2100' as input, search the excel table to check which row this value exist and then choose the value of 'Power' in this row.

Hope the query is now a bit clearer.