Did come across your earlier posting in .newusers, but couldn't grasp your
set-up/issue.

Think your setup description is incomplete. Explain and illustrate your
set-up in Sheet7, eg paste what you have in the vlookup's table array
Sheet7!$C$19:$D28.

I can presume that C19:C28 in Sheet7 possibly contains the lookup years, eg:
2002, 2003 . but I don't know what value that the vlookup is returning, ie
what's in D19:D28, and how the vlookup/its result relates to your question:
.. how do I get it to put a number in the 26th & 39th year?

Also, is there a possible inconsistency somewhere in that the vlookup table
array houses only 10 lookup years C19:C28 but you have 41 lookup years
placed in B2:AP2 in your formula sheet, viz: 2002 - 2042 (your vlookup is
looking for exact match, hence there should be at least 41 lookup years in
Sheet7's table array, no?)

Could you also explain / illustrate further on this part:
The number in the reference cells on Page 7 is variable depending on a
number input into another cell on Page 7.
For instance an article installed in 1995 to be replaced in 13 years would
be replaced in 2008.

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Duplatt" wrote in message
...
I have a 40 year Capital Item Replacement Program.
This formula is in Row 4 , Columns B thru AP
=if(ISNA(VLOOKUP(H2,Sheet7!$C$19:$C$D28,2,False)), 0,VLOOKUP(H2,Sheet7!$C$19:$D$28,2,False))
Row 2, Column B thru AP =2002 to 2042. Therefore B2=2002 & H2 = 2008 etc.
The number in the reference cells on Page 7 is variable depending on a
number input into another cell on Page 7.
For instance an article installed in 1995 to be replaced in 13 years would
be replaced in 2008. So far it works and puts a number in cell H4.
My question, how do I get it to put a number in the 26th & 39th year?
Any help appreciated.
Thank You -- Duane Platt