3 Options, results depend on option selected

Originally Posted by arthurbr

Another option

=a20*lookup(ae16,{1,2,3},{.27,.25,.22})+$B$5

Thanks arthur and boots, will try both options.

This is the start point for what will be a much bigger formula.

Thanks
Mike