This is an INDEX/MATCH formula: =INDEX(setingsDBase,MATCH(D9,nfDrinksList,0),2) [See it used in the screenshot below] It is a powerful time saving formula constructed using 2 different functions - enabling timely and convenient extraction of data from a database while reducing the chances of user entry errors being made during routine data recording of product sales record Index/Match […]