In various real-world scenarios, you may need to extract values of a specific column, row, or even a cell in a table or search for a specific field in a record or item in a list. There are several methods and different functions to reference specific values in a table, list, or record. This chapter explores various Power Query functions for referencing data, including extracting the first or last N items or rows, retrieving middle items or rows, and extracting values based on specific conditions in real-word problems. Before starting the problems in this section, let's review some tips for referencing.