title: How to VLOOKUP one value out from a cell with multiple values separated by comma?
body: <p>How to VLOOKUP one value out from a cell with multiple values separated by comma?</p>
  
  <p>For example, I am trying to get the Project ID of the SKU in C2. However, in A:A, there are multiple values in a cell which are separated by a comma. A simple VLOOKUP won't work.</p>
  
  <p><a href="https://i.stack.imgur.com/QxFuz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QxFuz.png" alt="VALUES"></a></p>