For Loop condition using vlookup function

3 次查看（过去 30 天）

James 2020-7-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/560435-for-loop-condition-using-vlookup-function

评论： Stephen23 2020-7-8

Not sure how to use the for loop with this function. Can anyone help. Thanks. Any help is appreiciated.

The code does not increment through the index(i) or the basenames(i) if they exist. I want them to skip the raw(i) if it doesn't exist and go to the next basename value.

basenames = {'Red' 'Green' 'Orange' 'Purple' 'Pink'};
nbase = length(basenames);
raw = cell(nbase, 1);
for K = 1 : nbase
    FileToLoad = [basenames{K} '.xls'];
    if exist(FileToLoad, 'file')
      [~,~,raw{K}] = xlsread(FileToLoad);
    end
end

What I would like to do here is run a for loop that uses the vlookup function from file exchange https://www.mathworks.com/matlabcentral/fileexchange/29233-vlookup-similar-to-ms-excel-function

for i = 1:nbase
    [basenames(i),index(i)] = vlookup(raw(i), 'column name', 2, 1);
    basenames(i) = cell2mat(basenames(i));
end

What I want to happen is that with the vlookup function I search the .xls file that was previously read into raw (if it exists), then lookup values in column 2 if column 1 label is "column name". Then that puts those values in index. This should loop through only if the raw(i) value exists.

4 个评论
显示 2更早的评论隐藏 2更早的评论

James 2020-7-8

在 MATLAB Online 中打开

The first part of the code does index through all of the basenames and the code does skip the raw if the basemanes does not exist as you have mentioned.

I would like to run a loop that uses indexing similar to the vlookup function to search the .xls file that was previously read into raw (if it exists), then lookup values in column 2 if column 1 label is "column name". Then that puts those values in index. This should loop through only if the raw(i) value exists.

Maybe there is an easier way to do this using basic indexing?

for i = 1:nbase
    [basenames(i),index(i)] = vlookup(raw(i), 'column name', 2, 1);
    basenames(i) = cell2mat(basenames(i));
end

I'm only using the referenced vlookup function from file exchange because I'm having a hard time with the basic indexing.

Any help is greatly appreciated.

Stephen23 2020-7-8

Please help us by clicking the paperclip button to upload a sample file.

Based on your previous comment you could try strcmp on the first column and then use the returned logical indices to select the required values from the second column.

请先登录，再进行评论。

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