Row position and find value

I have having some trouble with locating the position of the row in a table and then using that same row to find the value in column 3.

I first used:

Accelval=find(strcmp(mergetable1{:,1},AccelSN),1) to find the value where the first column matches the variable where the user has an input. The I would like to find the row position of this value. After determining the row position, I must create a new variable that uses the row position to find the value in column 3.

Any suggestions?

Answer 1

[madhan ravi]

Replace

Accelval

with

 [rows, columns] = ... and use the rows to index the table of column 3

[Alexandra Philip]

Thank you. So, just for clarification, I would use:

[rows, columns]=find(strcmp(mergetable1{:,1},AccelSN),1)

BIA1=mergetable1{rows,3}

[madhan ravi]

Yes