calling cells that don't = 0, without if statement

**lovethepirk** · 12-15-2009, 08:52 PM

http://img709.imageshack.us/img709/3918/excel.jpg

I am trying to create a financial worksheet and it is complete except for one issue I cannot figure out. Before I elaborate, I think I could do this with a ton of if statements but if I create a monthly worksheet this is not feasible...

If the user selects 30 years of investing I am fine b/c the future value of the investment will rest in my last cell provided. BUT if they select 25 years of investing there are 5 cells left open.

I need to call this cell in another area of the worksheet, but given we do not know what the investor is going to select for years of investing I do not know what cell to call. A bunch of if statements could work...eliminating any cells that = 0, but if I do monthly this would get crazy.

Any help is appreciated and I can send the worksheet to you if you like.

---I uploaded the worksheet...the cell reference in F3 needs to be able to call the last cell the user's fund requires in column B, if statements might get ugly on a monthly basis

Thanks,

lovethepirk

**Palmetto** · 12-15-2009, 08:57 PM

Suggested formula removed.

darkyam posted a more efficient approach.

**darkyam** · 12-15-2009, 08:59 PM

How about Index(B:B,C1+11)? This assumes C1 is where the number of periods is stored.

**lovethepirk** · 12-15-2009, 11:19 PM

Perfect...Thank you both very much, that was what I needed!

I never heard of the index function before, I love learning new things, thanks...I will be using that function in the future!!!!

ltp