public void LookupShouldReturnResultFromMatchingSecondArrayHorizontalWithOffset()
{
var func = new Lookup();
var args = FunctionsHelper.CreateArgs(4, "A1:C1", "B3:D3");
var parsingContext = ParsingContext.Create();
parsingContext.Scopes.NewScope(RangeAddress.Empty);
var provider = MockRepository.GenerateStub<ExcelDataProvider>();
provider.Stub(x => x.GetCellValue(WorksheetName,1, 1)).Return(1);
provider.Stub(x => x.GetCellValue(WorksheetName,1, 2)).Return(3);
provider.Stub(x => x.GetCellValue(WorksheetName,1, 3)).Return(5);
provider.Stub(x => x.GetCellValue(WorksheetName,3, 2)).Return("A");
provider.Stub(x => x.GetCellValue(WorksheetName,3, 3)).Return("B");
provider.Stub(x => x.GetCellValue(WorksheetName,3, 4)).Return("C");
parsingContext.ExcelDataProvider = provider;
var result = func.Execute(args, parsingContext);
Assert.AreEqual("B", result.Result);
}
