Afraid it's still tough to figure out what's actually happening over there

Perhaps you could upload a working sample of your actual* file
via a free filehost & post the link to it in response here?

You could use either of these free filehosts:
http://www.freefilehosting.net/
http://cjoint.com/index.php

*desensitize it as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Duplatt" wrote in message
...
Max. Thank you for responding
This is the range on page 7. There are several ranges like this.
The program is for tracking when to replace Capital items for our condo
association. This particular range is for 'Porch Rails' the 13 is a
variable.
if changed to 14 then column D would change correspondingly.

Sheet 3 lists all the items to be replaced in the A column
Sheet 3 row 2 lists all the years fromm 2002 to 2042
Each cell below row 2 has the Vlookup formula.
It works fine but, only for the years listed on sheet 7. C19:D28.
I think that by adding more columns for the lookup range it would work.
I don't know how to add additional Vlookup's to the formula
Any help appreciated
Merry Christmas - Duane
C D Porch Rails 13
Built Replace Quantity
19 1995 2008 4
1996 2009 7
1997 2010 4
1998 2011 1
1999 2012 8
2000 2013 3
2001 2014 2
2002 2015 2
2003 2016 0
28 2004 2017 0