Matching two columns from an imported table to find the corresponding value in the 5th column.
2 views (last 30 days)
Show older comments
Samuel Ofosu-Yeboah
on 2 Feb 2022
Commented: Samuel Ofosu-Yeboah
on 2 Feb 2022
I have a 401 x 12 table that was imported from excel into matlab. I want a function that returns a value from the 5th column when I give two values from the first two columns.
2 Comments
Accepted Answer
Enrico Gambini
on 2 Feb 2022
Edited: Enrico Gambini
on 2 Feb 2022
One method to extract what you want could be
temp=input("Insert temperature: \n"); %here you insert the parameters in the command window
%Otherwise you can do manually from the code
temp=360; %you can change it
Then you can create your function code file
function enthalpy=find_enthalpy(temp)
idx=find((Table.Temperature(:)==temp); %i called "Table" your table from excel
enthalpy=Table.Enthalpy(idx);
fprintf("The enthalpy is :",enthalpy); %not necessary
end
From your script, or directly from command window you can call the function
enthalpy=find_enthalpy(temp)
Let me know if works
5 Comments
Enrico Gambini
on 2 Feb 2022
If the pressure-temperature relation is univocal you can insert only the temperature. I edited
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!