Using Index and Match Functions To Look Up Values in Numbers
You can use the MATCH function to get the location of a value in a row or column. You can also use the INDEX function to grab the value of a cell at a given location. This allows you to make 2-dimensional lookup tables to find values based on two variables. In this example, one table shows prices based on a store name and a product name. The other table will look up a price from the first table given the store and product.