Create a range from a given cell using xlsread

Is it possible to search for a given string in a column A of an excel sheet, then obtain the number in the same row, but in column B and then to use this number as the last value in a range:

i.e. if the number in the cell adjacent to where "Count" is is 15000, the perform:

   [ndata, text]=xlsread(file,'A1:A15000');

Thanks Jason

Answer 1

[Jason]

I think I've worked out the solution:

[~,~,rawData] = xlsread(file,'A1:A50')
 dummy='Count';
 idx=find(strcmp(rawData(:),dummy),1)
 ct=sprintf('B%d:B%d',idx,idx)
 [count, ~]=xlsread(file,ct)

[Jason]

My excel file is saved as a CSV, is xlsread the quickest way to read in the data as there are 800k lines?

Thanks