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
3 Likes
perfect,
thx @Christiaan_Huizer