| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VLOOKUP + Something
Re-posted by OP in .misc:
http://tinyurl.com/2dkqo8 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
