Not case sensitive

I need to lookup text in a table, but I need it to work not case sensitive.

is there a way to do that in a formula?
or can i convert a column to all capps (would b a workable workaround)

indeed @Pieter_Lesage , you need to apply a case sensitive alike logic like below with Lower()

hope it helps, cheers, christiaan


thx @Christiaan_Huizer