Formula for matching Data IN and OUT data from another sheet

[Kenor]

Hi All,

I would like to match the Data IN and Data OUT in my Database.

I have used the formula below to match the data before.

=IFERROR(INDEX('Register OUT'!$A$3:$K$2000,MATCH(1,(DataBase!$C$2='Register OUT'!$C$3:$C$2000)*(DataBase!$D$2='Register OUT'!$D$3:$D$2000)*(DataBase!$E$2='Register OUT'!$E$2000)*(DataBase!$I$2='Register OUT'!$I$3:$I$2000),0),7),0)

Can see the image for details.
>> I want to get Data OUT from Register OUT sheet and match with Data IN in Database Sheet automatically.

But do not know why this time the formula did not become.

 

[Alex Blakenburg]

Should the test on Column E not cover the same range as all the others ?
Just formatting your formula it looks like the below.
I imagine it should have:- *(DataBase!$E$2='Register OUT'!$E$3:$E$2000)

=IFERROR(
INDEX('Register OUT'!$A$3:$K$2000,
    MATCH(1,(DataBase!$C$2='Register OUT'!$C$3:$C$2000)
                            *(DataBase!$D$2='Register OUT'!$D$3:$D$2000)
                            *(DataBase!$E$2='Register OUT'!$E$2000)
                            *(DataBase!$I$2='Register OUT'!$I$3:$I$2000),0),
7),0)

 

[Kenor]

Should the test on Column E not cover the same range as all the others ?
Just formatting your formula it looks like the below.
I imagine it should have:- *(DataBase!$E$2='Register OUT'!$E$3:$E$2000)

=IFERROR(
INDEX('Register OUT'!$A$3:$K$2000,
    MATCH(1,(DataBase!$C$2='Register OUT'!$C$3:$C$2000)
                            *(DataBase!$D$2='Register OUT'!$D$3:$D$2000)
                            *(DataBase!$E$2='Register OUT'!$E$2000)
                            *(DataBase!$I$2='Register OUT'!$I$3:$I$2000),0),
7),0)

Sorry, I couldn't upload image on previous email.

Kindly see attached image.

 

[Kenor]

Should the test on Column E not cover the same range as all the others ?
Just formatting your formula it looks like the below.
I imagine it should have:- *(DataBase!$E$2='Register OUT'!$E$3:$E$2000)

=IFERROR(
INDEX('Register OUT'!$A$3:$K$2000,
    MATCH(1,(DataBase!$C$2='Register OUT'!$C$3:$C$2000)
                            *(DataBase!$D$2='Register OUT'!$D$3:$D$2000)
                            *(DataBase!$E$2='Register OUT'!$E$2000)
                            *(DataBase!$I$2='Register OUT'!$I$3:$I$2000),0),
7),0)

Thanks Alex,

When you do like that, it make more clear to me.
Now I already know why it doesn't function.
I make mistake in my formula
Wrong >> *(DataBase!$E$2='Register OUT'!$E$2000)
Correct >> *(DataBase!$E$2='Register OUT'!$E$3:$E$2000)

Thanks again.

 

[Alex Blakenburg]

Yes, I find it much easier to read that way. Alt+Enter gives you the new line.
Thanks for letting me know. Glad I could help.

 

[Kenor]

Yes, I find it much easier to read that way. Alt+Enter gives you the new line.
Thanks for letting me know. Glad I could help.

Thanks again..