FYI this is a begging plea for help.

I have an excel file with 2 sheets of data

on sheet 1 i have 2 colums, Data A & Data B

One sheet 2 I Have Data C
Basically On Sheet 2, Data C contains 2483 Unique records
Then On Sheet 1, Contains about 54k unique records , the Data A colume
contains Unique Numbers, Data B contains the First 6 Alpha/numeric digits of
the Same Data , located in sheet 2.

What i need, is to be able to Locate & Match Records first then append data
in a new cell or sheet.

Ie

SHEET 1
MYID1 | MY ID 2 |
1 | AAC 211 |
2 | AAC 211 |
3 | AAC 212 |
4 | AAC 212 |
5 | ESD 213 |
6 | DSD 101 |
7 | DSD 101 |

SHEET 2
MID3 |
AAC 211-002
AAC 211-003
AAC 211-004
AAC 211-005
AAC 211-006
AAC 211-007
AAC 212-001
AAC 212-002
AAC 212-003
AAC 212-004
AAC 212-005


Desired result
SHEET NEW
MYID1 | MID3-MYID2 |
1 | AAC 211-002 |
1 | AAC 211-003 |
1 | AAC 211-004 |
1 | AAC 211-005 |
1 | AAC 211-006 |
2 | AAC 212-001 |
2 | AAC 212-002 |
2 | AAC 212-003 |
2 | AAC 212-004 |
2 | AAC 212-005 |
2 | AAC 212-006 |
2 | AAC 212-007 |
2 | AAC 212-008 |