matching fields formula

[Imran Azam]

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

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

 

[AhoyNC]

Maybe something like this:

Excel Workbook
	A	B	C	D
1	Data 1
2	NAME	POSTCODE	ID
3	Alan	7861	7786178145	Match
4	Sam	2401	4702315656	No Match
5	Becky	5673	5018894578	No Match
6	Alan	2531	7786179898	No Match
7
8	data 2
9	Name	Postcode	ID
10	AL	(7861)	(7786178145)
11	SA	(2434)	(6752224587)
12	BE	(5673)	(4448894578)
13	AL	(2531)	(8786179899)
Sheet