You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.
If you have a spreadsheet containing the stocks in a shop or something similar, and you need to count the comma-separated values in a single cell, here is how you can get the job done. There is a ...