W
WIJ
Hi all,
This is the first time I have posted on here.. I am trying to make up the
following nested IF staement (I am drawing alot of information from a
database). It all works for me exept for the last nested If statement
line(Administration). I dont know why this is as I have followed the same
procedues as the other lines...I not sure if this makes sense or not.
=IF(HOURS!C12=0,VLOOKUP(HOURS!D12,PROJECTS!$A$2:$B$25,2),
IF(HOURS!C12=1,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=2,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=4,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=5,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=6,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=7,VLOOKUP(HOURS!D12,MajorTasks!$A$2:$B$3,2),
IF(HOURS!C12=8,VLOOKUP(HOURS!D19,ADMINISTRATION!$A$2:$B$10,2,4),
NOT IN DATABASE))))))))
This is the first time I have posted on here.. I am trying to make up the
following nested IF staement (I am drawing alot of information from a
database). It all works for me exept for the last nested If statement
line(Administration). I dont know why this is as I have followed the same
procedues as the other lines...I not sure if this makes sense or not.
=IF(HOURS!C12=0,VLOOKUP(HOURS!D12,PROJECTS!$A$2:$B$25,2),
IF(HOURS!C12=1,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=2,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=4,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=5,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=6,VLOOKUP(HOURS!D12,SYSTEMS!$A$2:$B$127,2),
IF(HOURS!C12=7,VLOOKUP(HOURS!D12,MajorTasks!$A$2:$B$3,2),
IF(HOURS!C12=8,VLOOKUP(HOURS!D19,ADMINISTRATION!$A$2:$B$10,2,4),
NOT IN DATABASE))))))))