def test_CHOOSE(self):
self.assertEqual(lookup.CHOOSE('2', 2, 4, 6), 4)
def test_CHOOSE_with_negative_index(self):
self.assertIsInstance(lookup.CHOOSE(-1, 1, 2, 3),
xlerrors.ValueExcelError)
def test_CHOOSE_with_too_large_index(self):
self.assertIsInstance(lookup.CHOOSE(5, 1, 2, 3),
xlerrors.ValueExcelError)