ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   VLOOKUP + Something (https://www.excelbanter.com/new-users-excel/170064-vlookup-something.html)

Duplatt

VLOOKUP + Something
 
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


Max

VLOOKUP + Something
 
Re-posted by OP in .misc:
http://tinyurl.com/2dkqo8
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---




All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com