Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine Logical if and Vlook up | Excel Worksheet Functions | |||
Combine 2 sheets into 1 that will update w/new data | Excel Worksheet Functions | |||
Combine data from two sheets in two one | Excel Programming | |||
How to append/combine (not add) data in several sheets into one? | Excel Discussion (Misc queries) | |||
Vlook up for matching data in two seperate sheets | Excel Discussion (Misc queries) |