hey! thanks so much for all your replies. Unfortunately I can't get it to work. the best i achieve is getting #VALUE! as cell value
I know I've got the correct left-hand-side of the equation, its something with the right-hand-side which is not wanting to cooperate.
There has to be a way to write "[index(Upper(L:L),)]" generically (as reminder, the L:L range should be replaced by something resembling activecell.entirecolumn to have it use the selected column)

Also, still on topic, does anyone have any input on UCASE vs UPPER methods? I tried looking for it online but couldn't find a site which combined both.