hi everyone, i've been playing around with index/match/lookup but haven't been able to find a solution, hope to get some helps. below is just a small sample of my huge table. thanks
table1 is my source table with individual name on each row by date(this go down by thousand of rows).
table 2 is my main table that i want to return a value if it match date and name from table 1.
i originally used vlookup and endedup missing all the data since it only returns the first match value
i'm looking for a function that will look at both columns on both tables and return either 1 or 0 on result column.
i appreciate your help!
table1 is my source table with individual name on each row by date(this go down by thousand of rows).
table 2 is my main table that i want to return a value if it match date and name from table 1.
i originally used vlookup and endedup missing all the data since it only returns the first match value
i'm looking for a function that will look at both columns on both tables and return either 1 or 0 on result column.
i appreciate your help!
table 1 | table 2 | ||||
Date | last name | Date | last name | result | |
09/01/22 | Smith | 09/01/22 | Luo | 1 | |
09/01/22 | Toledo | 09/01/22 | Smith | 1 | |
09/01/22 | Luo | 09/01/22 | Tran | 0 | |
09/05/22 | Smith | 09/02/22 | Kani | 0 | |
09/05/22 | Toledo | 09/03/22 | Luo | 0 | |
09/10/22 | Uro | 09/04/22 | Tran | 0 | |
09/05/22 | Toledo | 1 | |||
09/05/22 | Uro | 0 | |||
09/10/22 | Kani | 0 |