Excel handles table lookups very cleanly and quickly, and the =VLOOKUP() and =MATCH() functions allow you to move through data tables easily. One common example of how to use =VLOOKUP() and =MATCH() is pulling information out of an IRS tax table. The VLOOKUP() function is used to find the row of the table, and the =MATCH() function is used to determine which column is used. Between them, you get a dynamically readable table lookup. Tips Writer Bio
