Hi,
I am trying to use this formula below to calculate costs based on reference
letters, but now want to exclude some of the letters used in it so it doesn't
include certain costs in to the equation.

The problem is it is only returning a result of zero. Any ideas why this
is happening?

=IF(OR('Exec Sum'!D11="C",'Exec Sum'!D11="L",'Exec
Sum'!D11="M"),0,LOOKUP($F$11,{0,"A/B","C","D","E","F","G","H","I","J","K","L","M"},'M arket
Summary'!Q9:Q21)+IF(OR('Exec Sum'!D12="C",'Exec Sum'!D12="L",'Exec
Sum'!D12="M"),0,LOOKUP($F$11,{0,"A/B","C","D","E","F","G","H","I","J","K","L","M"},'M arket Summary'!$Q$9:$Q$21)+IF..................

thanks for looking!
--
Peet