video1.0<iframe src="https://www.loom.com/embed/a39a4569d95244b7886026f3c70812c7" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/a39a4569d95244b7886026f3c70812c7-00001.gif378.76IMPORTANT: If you're experiencing odd behavior, please reach out to use directly at -- support@clay.com -- so the team can troubleshoot for you. Some things can "break" because of how programming languages may interpret some values which may be a bit more technical to spot. You can use the latest version of Lookup called Lookup Multiple Rows too, not just the one in this video :) IMPORTART NOTES: Make sure that your column is spelled/named exactly the same as what you tell the prompt below to look for i.e. Column name = UniqueID so I'll prompt to search for "UniqueID"; example 2: Column name = Unique Number so I'll as the prompt to search for "Unique Number"... The Column type i.e. Text or Number shouldn't matter, but if you do notice issues, changed both to Text. PROMPT: Only run if /{UniqueID} is not empty, then return a number label depending on which number of occurrences any of the "UniqueID" fields from the following array /{lookup} match /{UniqueID} For example, if the first value of "UniqueID" you find from the array is true, then return 1, if it's the second value then return 2 and so on Otherwise return 2