Vlook up to combine data in many sheets
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,FA LSE)),0,VLOOKUP($C$5,Gaji_Harian1!$C$5:$N$500,6,FA LSE))+IF(ISNA(VLOOKUP($C6,'Gaji_Harian1 (2)'!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,'Gaji_Ha rian1 (2)'!$C$5:$N$500,6,FALSE))+IF(ISNA(VLOOKUP($C6,'Ga ji_Harian1 (3)'!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,'Gaji_Ha rian1 (3)'!$C$5:$N$500,6,FALSE)) Thanks for any help. Frank |
Vlook up to combine data in many sheets
Two points
--The cell reference is VLOOKUP($C6, OR VLOOKUP(C$5 --Missing single around the 1st sheet name. If this post helps click Yes --------------- Jacob Skaria "Frank Situmorang" wrote: 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,FA LSE)),0,VLOOKUP($C$5,Gaji_Harian1!$C$5:$N$500,6,FA LSE))+IF(ISNA(VLOOKUP($C6,'Gaji_Harian1 (2)'!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,'Gaji_Ha rian1 (2)'!$C$5:$N$500,6,FALSE))+IF(ISNA(VLOOKUP($C6,'Ga ji_Harian1 (3)'!$C$5:$N$500,6,FALSE)),0,VLOOKUP($C$5,'Gaji_Ha rian1 (3)'!$C$5:$N$500,6,FALSE)) Thanks for any help. Frank |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com