Excel Data Validation

[danb]

Hello,

I have a financial spreadsheet. Some of my income sources are 12 Annual payments, while others are 26 Annual Payments.

Can someone help me figure out how to do the following:

If Income_ESI!D1 has a value of Extras!C2, then populate Income_ESI!E1 with the value from Extras!D2
If Income_ESI!D1 has a value of Extras!C3, then populate Income_ESI!E1 with the value from Extras!D3
If Income_ESI!D1 has a value of Extras!C4, then populate Income_ESI!E1 with the value from Extras!D4

I've attached the spreadsheet and am open to alternate ways of achieving the same goal

Once Income_ESI!E1 has the proper payment frequency value I'm going to use this number on Income_TOTAL to force each income contribution source to be in a monthly format

For example:
Cell F8 would have the following formula
=(Income_ESI!E1*Income_ESI!F8)+(Income_LLC!E1*Income_LLC!F8)+(Income_VA!E1*Income_VA!F8)

[deborah]

Income_ESI!E1  has the formula    IF(Income_ESI!D1 = Extras!C2,Extras!D2,0)      (I assume you want 0 if they are not equal)

ditto for the rest

[danb]

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?

[deborah]

=VLOOKUP(Income_ESI!D1,Extras!C:D,2,FALSE)

[danb]

Thanks! You have been very helpful.