How to Extract Data from a List Using Excel Formula (5 Methods) Pressing Ctrl + Shift + Enter applies the formula and returns all the results If we choose a product and a region, this formula will filter the list and show the names related to these multiple criteria
Vlookup how to find the price by name in Excel - Stack Overflow You can't use Vlookup() to return price by product name because Vlookup() always search on first column of table and in your case product name is second column (as per your current formula) Use INDEX() MATCH() in this case like-