How to get the value corresponding to the data in an excel file

Hi,

I am trying to write an algorithm that calculates the values entered by the user and obtains a result, and prints the value in the 1st column corresponding to this result.

For now, let's ignore the initial calculations and get the result of the calculation directly from the user. This is how I did it;

T = readtable('katalog.xlsx');
in = input('Enter Input\n','s');

For example, the user found the answer 13.2 as a result.

Matlab should compare this result with the closest value in the excel file and output the text in the 1st column corresponding to that value.

You can check my excel file in the attachment.

Despite doing a lot of research, I couldn't find exactly how to do this. If you can help me with this, that would be great.

Answer 1

[Arif Hoq]

try this:

A=readtable('katalog.xlsx','ReadVariableName',false);
B=table2array(A(2:end,2:end));
D=str2double(string(B));
userinput=36.1;  % you can defined in a function "input"
[~,~,idx]=unique(round(abs(D-userinput)));
minVal=D(idx==1)

minVal = 36

[row col]=find(D==minVal);
output=A(row+1,1)

output = table
     Var1  
    _______

    {'AB8'}