Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
hi
I am trying to match data i have in two files to see if they match based on some conditions
Below is data 1 and data 1
Data 1
<tbody>
</tbody>
data 2
<tbody>
</tbody>
I am trying to create a formula that will match the first 2 characters of Name of data 2 to Name of data 1 and match the numbers only of postcode from data 2 to postcode data 1, match numbers only of ID in data 2 to ID of data 1 , AND if it all matches return match if no return not match
can this be done?
thank you for any help
I am trying to match data i have in two files to see if they match based on some conditions
Below is data 1 and data 1
Data 1
NAME | POSTCODE | ID |
Alan | 7861 | 7786178145 |
<tbody>
</tbody>
data 2
Name | Postcode | ID |
AL | (7861) | (7786178145) |
<tbody>
</tbody>
I am trying to create a formula that will match the first 2 characters of Name of data 2 to Name of data 1 and match the numbers only of postcode from data 2 to postcode data 1, match numbers only of ID in data 2 to ID of data 1 , AND if it all matches return match if no return not match
can this be done?
thank you for any help
Last edited: