If you take another look at that example I’ve altered it so it ignores case. No need to change the data in Goggle Sheets.
/edit - it’s an age-old trick used in programming: just convert both strings you’re comparing to lower (or upper) case before the comparison.