title: Googlesheet IF with multiple cases
body: <p>in my Google sheet table I have the first list with summary of invoices which are then separated to 4 lists according to parameters (manually). I need to know about all invoices from the first list, on which category/list they are.</p>
  <p>So for example - lists: Alphabet, abc, def, mno, xyz. In Alphabet is column &quot;list&quot;.
  How to write function which found invoice on another list according to ID (column B) from Alphabet and write name of the correct list to column &quot;list&quot;. I tried to write this function using IF, match, etc. But I still don't have solution. Can you help me please? Sorry for my English :-)
  <a href="https://i.stack.imgur.com/9sisd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9sisd.png" alt="enter image description here" /></a></p>