Hi,
You may create a string array of your column A and use the "Find" command to return to corresponding row index, and then use the row index to access corresponding cell in column B.
An example would be:
//Append the string variables in column A as a string array
StringArray aa;
range r1=col(1);
aa.Append(r1);
//Pop up a dialog to let user input a date.
getstring (Type the date here);
//%B stores the user-input date as a string variable
string date$=%B;
//return to the row index of the matching date in string array
int nn = aa.Find(date$);
//return to the corresponding cell of col B, the variable type may need to change according to your data
double sess=col(2)[$(nn)];
sess=;
You might refer to the following two pages for more information and examples of the StringArray:Find and getstring command:
http://www.originlab.com/www/helponline/Origin/en/Programming/mergedProjects/LabTalk/LabTalk/StringArray_(object).html#Find
http://www.originlab.com/www/helponline/Origin/en/programming/mergedProjects/LabTalk/LabTalk/GetString_(command).html
Please note that the hyperlink might not work for direct clicking, then you will need to copy and paste the address into your browser, sorry for the inconvenience.
Kathy
Originlab
setting a variable to a cell value
Posted - 06/25/2012 : 4:53:32 PM
