F
Frank Situmorang
Hello,
I tried to make Vlookup using a common key for 3 sheets but, It seem not to
work, and when I coppy it to the row below, it repeats the same the result of
formula in the 1st row.
This is my formula:
=IF(ISNA(VLOOKUP($C6,Gaji_Harian1!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,Gaji_Harian1!$C$5:$N$500,6,FALSE))+IF(ISNA(VLOOKUP($C6,'Gaji_Harian1
(2)'!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,'Gaji_Harian1
(2)'!$C$5:$N$500,6,FALSE))+IF(ISNA(VLOOKUP($C6,'Gaji_Harian1
(3)'!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,'Gaji_Harian1
(3)'!$C$5:$N$500,6,FALSE))
Thanks for any help.
Frank
I tried to make Vlookup using a common key for 3 sheets but, It seem not to
work, and when I coppy it to the row below, it repeats the same the result of
formula in the 1st row.
This is my formula:
=IF(ISNA(VLOOKUP($C6,Gaji_Harian1!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,Gaji_Harian1!$C$5:$N$500,6,FALSE))+IF(ISNA(VLOOKUP($C6,'Gaji_Harian1
(2)'!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,'Gaji_Harian1
(2)'!$C$5:$N$500,6,FALSE))+IF(ISNA(VLOOKUP($C6,'Gaji_Harian1
(3)'!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,'Gaji_Harian1
(3)'!$C$5:$N$500,6,FALSE))
Thanks for any help.
Frank