Find a specific number in an imported excel sheet

Hey everyone, I have the matrix in the attached file and call it with

filename='Matrix.xlsx'
B=xlsread(filename)

Then I would give it a number for column A and a number which is in column B2 to I2. After that the result should be the Number in Row 1. For example: I give it 9 (A12) and 14.38 (B12) and the result should be 2 (B1). I thought about using the [row,col] function?

Thank you!

Answer 1

[KL]

 [rowind,colind] = find(B(:,1)==9 & B(:,2:end)==14.38)

Do you mean this?

[Tim]

Thank you for your quick answer!