I searched many result and method in internet for Microsoft OS, and downloaded the sample and template. Yes it's work in Mac excel 2011.

But when I create a new sheet and following the step by tutorial can't work. can't input the formula in picture. showing "Reference is not valid"

Any solution can do it (lookup picture) in Mac Excel 2011? Thanks a lot.