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

[TABLE="width: 500"]
<tbody>[TR]
[TD]NAME[/TD]
[TD]POSTCODE[/TD]
[TD]ID[/TD]
[/TR]
[TR]
[TD]Alan[/TD]
[TD]7861[/TD]
[TD]7786178145[/TD]
[/TR]
</tbody>[/TABLE]

data 2 [TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Postcode[/TD]
[TD]ID[/TD]
[/TR]
[TR]
[TD]AL[/TD]
[TD](7861)[/TD]
[TD](7786178145)[/TD]
[/TR]
</tbody>[/TABLE]


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