Hello!
good day!
im asking for a help regarding my formula.
so i have 2 different sheets and trying to combine them in one sheet.
i want my formula to check if my (ACC no in the weekly sheet) is equal to (ACC no in the daily sheet), if they are equal to be reflect in the (database sheet) and if not to skip and search for another (ACC no which are equal).
i have try to use the index match or IF condition with VLOOKUP but unfortunately it didn't work with me.
=IFERROR(INDEX(WEEKLY!$C64:$C$4000,MATCH(WEEKLY!$C64,DAILY!$D$6:$D$4000,0)),""
in the database sheet as u can see i got blank cells infact there are some ACC no which are equal but it didnt reflect.
kindly refer to the attachment
thank you.
good day!
im asking for a help regarding my formula.
so i have 2 different sheets and trying to combine them in one sheet.
i want my formula to check if my (ACC no in the weekly sheet) is equal to (ACC no in the daily sheet), if they are equal to be reflect in the (database sheet) and if not to skip and search for another (ACC no which are equal).
i have try to use the index match or IF condition with VLOOKUP but unfortunately it didn't work with me.
=IFERROR(INDEX(WEEKLY!$C64:$C$4000,MATCH(WEEKLY!$C64,DAILY!$D$6:$D$4000,0)),""
in the database sheet as u can see i got blank cells infact there are some ACC no which are equal but it didnt reflect.
kindly refer to the attachment
thank you.