matching fields formula

Imran Azam

Board Regular
Joined
Mar 15, 2011
Messages
78
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

NAMEPOSTCODEID
Alan78617786178145

<tbody>
</tbody>

data 2
NamePostcodeID
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:

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,619
Office Version
  1. 365
Platform
  1. Windows
Maybe something like this:
Excel Workbook
ABCD
1Data 1
2NAMEPOSTCODEID
3Alan78617786178145Match
4Sam24014702315656No Match
5Becky56735018894578No Match
6Alan25317786179898No Match
7
8data 2
9NamePostcodeID
10AL(7861)(7786178145)
11SA(2434)(6752224587)
12BE(5673)(4448894578)
13AL(2531)(8786179899)
Sheet
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,355
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top