P

#### Peet

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"},'Market

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"},'Market Summary'!$Q$9:$Q$21)+IF..................

thanks for looking!