public void HLookupShouldThrowIfNoMatchingRecordIsFoundWhenRangeLookupIsTrue()
{
var func = new HLookup();
var args = FunctionsHelper.CreateArgs(1, "A1:B2", 2, true);
var parsingContext = ParsingContext.Create();
var provider = MockRepository.GenerateStub<ExcelDataProvider>();
provider.Stub(x => x.GetCellValue(0, 0)).Return(new ExcelCell(2, null, 0, 0));
provider.Stub(x => x.GetCellValue(0, 1)).Return(new ExcelCell(3, null, 0, 0));
provider.Stub(x => x.GetCellValue(1, 0)).Return(new ExcelCell(3, null, 0, 0));
provider.Stub(x => x.GetCellValue(1, 1)).Return(new ExcelCell(5, null, 0, 0));
parsingContext.ExcelDataProvider = provider;
var result = func.Execute(args, parsingContext);
}