Calling Excel and Matching Data in Matlab

I would like to call an excel data like in the picture. I have to call only a few data but need to followed by the next data in the next right column. Just like this if I called AAI, I wish the next data like 3 41.22654 will automatically followed.

Answer 1

[dpb]

Consider using readtable to bring the data in; making the ID column categorical data type will have advantages in writing lookup tests. Then there are any number of ways to find the given row(s) depending on just what it is you need, specifically. Look at the examples for table on how to address data therein for pointers...

[Geofisika 2014]

can you give me an example of it? I am a newbie in matlab, thank you

[dpb]

Read Excel sheet https://www.mathworks.com/help/releases/R2016b/matlab/ref/readtable.html#buggjy1-6

Access table data https://www.mathworks.com/help/releases/R2016b/matlab/matlab_prog/access-data-in-a-table.html

Working with categorical data https://www.mathworks.com/help/releases/R2016b/matlab/categorical-arrays.html

Just dive in at the keyboard in command window and 'spearmint...fastest way there is to learn.

If'en then get stuck show us what you've gotten done and tried and folks'll be happy to show pointers.