private ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval lookupEval, ValueEval indexEval,
ValueEval returnEval, String notFound, LookupUtils.MatchMode matchMode,
LookupUtils.SearchMode searchMode, bool isSingleValue)
{
try
{
ValueEval lookupValue = OperandResolver.GetSingleValue(lookupEval, srcRowIndex, srcColumnIndex);
TwoDEval tableArray = LookupUtils.ResolveTableArrayArg(indexEval);
int matchedRow;
try
{
matchedRow = LookupUtils.XlookupIndexOfValue(lookupValue, LookupUtils.CreateColumnVector(tableArray, 0), matchMode, searchMode);
}
catch (EvaluationException e)
{
if (ErrorEval.NA.Equals(e.GetErrorEval()))
{
if (string.IsNullOrEmpty(notFound))
{
if (returnEval is AreaEval)
{
AreaEval area = (AreaEval)returnEval;
int width = area.Width;
if (isSingleValue || width <= 1)
{
return(new StringEval(notFound));
}
return(new NotFoundAreaEval(notFound, width));
}
else
{
return(new StringEval(notFound));
}
}
return(ErrorEval.NA);
}
else
{
return(e.GetErrorEval());
}
}
if (returnEval is AreaEval)
{
AreaEval area = (AreaEval)returnEval;
if (isSingleValue)
{
return(area.GetRelativeValue(matchedRow, 0));
}
return(area.Offset(matchedRow, matchedRow, 0, area.Width - 1));
}
else
{
return(returnEval);
}
}
catch (EvaluationException e)
{
return(e.GetErrorEval());
}
}
private ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval lookupEval, ValueEval indexEval,
LookupUtils.MatchMode matchMode, LookupUtils.SearchMode searchMode)
{
try
{
ValueEval lookupValue = OperandResolver.GetSingleValue(lookupEval, srcRowIndex, srcColumnIndex);
TwoDEval tableArray = LookupUtils.ResolveTableArrayArg(indexEval);
ValueVector vector;
if (tableArray.IsColumn)
{
vector = LookupUtils.CreateColumnVector(tableArray, 0);
}
else
{
vector = LookupUtils.CreateRowVector(tableArray, 0);
}
int matchedIdx = LookupUtils.XlookupIndexOfValue(lookupValue, vector, matchMode, searchMode);
return(new NumberEval((double)matchedIdx + 1));
}
catch (EvaluationException e)
{
return(e.GetErrorEval());
}
}
