Try substituting NAME with Upper(Name) where ever/how ever it is refered to in your formula, this might produce an array formula, if so then confirm with Ctrl+Shift+Enter