Thanks Deborah,

I think i might have not been as clear as needed.

When I put in

If I select "26xAnnual" from the drop down list for D1

and have E1 with the following formula: =IF(Income_ESI!D1 = Extras!C3,Extras!D3,0)

E1 Has a Value of 2.66666667 which is Great and what I want.

However, If I select "12xAnnual" from the drop down list for D1

and have E1 with the following formula: =IF(Income_ESI!D1 = Extras!C3,Extras!D3,0)

E1 Has a Value of 0 which is not the desired outcome

The desired outcome would be 1.0000000000

How can i get both outcomes to be as expected?