match and index tutorial. These 2 functions are very often used together in place of vlookup. This example looks up IRS witholding for (1) wages, (2) marital status, and (3) number of deductions. 2 and 3 are combined in a single table (M2, S0, S3, etc.)