VLOOK UP function in Matlab

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

[Gautam Vallabha]

Do you have the data in MATLAB, in a 64000 x 3 matrix?

[Marek]

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.

Answer 1

[Oleg Komarov]

Use ismember

[Marek]

hmm...what does ismember mean?

[Walter Roberson]

See the documentation, http://www.mathworks.com/help/techdoc/ref/ismember.html