Using Index and Match Functions To Look Up Values in Numbers (
https://macmost.com/e-1647 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.
Watch video Using Index and Match Functions To Look Up Values in Numbers ( online without registration, duration hours minute second in high quality. This video was added by user macmostvideo 30 April 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 39,81 once and liked it 43 people.