G
Guest
hi,
I have 2 files, Files A (old) contained data in below order:-
Brand Type Unit Flag
AA 123 2 Yes
AB 234 No
No
In File B, data are organized in below order:-
Brand Type Unit Flag
AA 123 2
AB 234 3
CC 135 5
What I would like to know is how to compare each value in Brand, Type & Unit
whether they are the same in each file; if they are the same then the Flag
value in File A will be returned; else No will be retruned in File B.
Actually, I have tried out using Vlookup functions but unfortunately, this
function can only compare data in 1 column. So, is there any other functions
that can help in solving this problem?
Thanking in advanced.
I have 2 files, Files A (old) contained data in below order:-
Brand Type Unit Flag
AA 123 2 Yes
AB 234 No
No
In File B, data are organized in below order:-
Brand Type Unit Flag
AA 123 2
AB 234 3
CC 135 5
What I would like to know is how to compare each value in Brand, Type & Unit
whether they are the same in each file; if they are the same then the Flag
value in File A will be returned; else No will be retruned in File B.
Actually, I have tried out using Vlookup functions but unfortunately, this
function can only compare data in 1 column. So, is there any other functions
that can help in solving this problem?
Thanking in advanced.