VLOOK UP function in Matlab

2011 3 29
1 个回答
4 次查看（30 天）

0 个投票

Hi,
dealing with one solution. Being an excel user jumping to matlab. Problkem statement: Having excel table defined by 3 columns (Temperature, solar irradiation, absolute humidity). Each column represents around 64000 values. I need script (in excel it is vlookup func.)to find and write corect absolute humidity regarding defined 1)Temperature 2)solar irradiation. If 1,2 wouldnt match requirements defined, finding the closest value.
Cheers!
marek

2 个评论
显示 无 隐藏 无

Gautam Vallabha
Gautam Vallabha 2011-3-29
Do you have the data in MATLAB, in a 64000 x 3 matrix?
Marek
Marek 2011-4-20
Well, lets say I have 4 variables: A,B,C and D. So I have 4 columns (64000 x 4). First I need to calculate abs.humidity out of C,D and than search for this calculated value regarding A and B.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Oleg Komarov
Oleg Komarov 2011-4-20

0 个投票

Use ismember

2 个评论
显示 无 隐藏 无

Marek
Marek 2011-4-26
hmm...what does ismember mean?
Walter Roberson
Walter Roberson 2011-4-26
See the documentation, http://www.mathworks.com/help/techdoc/ref/ismember.html

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

提问:

Marek
Marek
2011-3-29

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by