excel x & y
2 views (last 30 days)
Show older comments
Alireza Lashgary
on 4 Aug 2016
Commented: Alireza Lashgary
on 4 Aug 2016
Hi there i read two columns from an excel file. first column is x and second is y. i get x from user , how can a i find y for that x?
for example user inputs 0.531 i must show 0.5103 or user inputs 0.536 i must show 0.5154
my matrix is 2x1000 ( 2 columns and 1000 rows) please help
0 Comments
Accepted Answer
Azzi Abdelmalek
on 4 Aug 2016
Edited: Azzi Abdelmalek
on 4 Aug 2016
If M is your matrix
M=[0.5310 0.5103;0.5320 .5080;0.5330 0.5144]
x=0.5310
idx=ismember(M(:,1),x)
y=M(idx,2)
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!