The TableLookup Function
The TableLookup function enables the calculation of an amount from a table. Typically this is used with tax tables, or other tables of tariffs. The normal tax calculation for South Africa for the 2008/09 tax year is based on this table (reproduced from the South African Revenue Services web site):