[ Ссылка ] The Lookup function can be useful if you want to automatically populate cells on one table with data from another, based on new data entered. For instance, you can enter products in one column and then have prices fill in automatically by having the Lookup function refer to a list of products and prices in a second table.
![](https://i.ytimg.com/vi/GPEnn9tv-cU/maxresdefault.jpg)