Left function formula with needing specified criteria

Hello!

I run a daily report and add information to a master database spreadsheet every day. I can't get my formula to what I need it to do.

I have a list of properties in our area with local property identification numbers & neighborhood numbers which are separated out for different people in our office. For the most part, I only need the first two digits for the local property number (Section A), but in some areas, I will also need the neighborhood number information (Section B). Section C, Column A is all of the different combinations that will be needed or what I use to use in a VLOOKUP formula previously with doing some manual work. I've also attached a sample spreadshett


Section A
In Sheet 1, Column N (local property number), I have the following information:

91-2730-0158
93-4319-0003
95-0220-0021
94-3969-0122

Section B
In Sheet 1, Column R (neighborhood number), I have this next set of information:

172220-074
371610-074
841408-074
472008-074

Section C
In Sheet 2, I have the following READ information:

Column A Column B
30 30 Ashlie
31 31 Ashlie
91 91 Eric S
92 92 Kim
93 93 Jason
94 - 851001 94 - 851001 Zach
94 - 851002 94 - 851002 Zach
94 - 851003 94 - 851003 Zach
94 - 851011 94 - 851011 Zach
94-471 94-471 Zach
94-472 94-472 Ashlie
95 95 Ashlie
96 96 Ashlie

How do I calculate the following on Sheet 1 to read the below:

Column AC2 91 - Eric S
Column AC3 93 - Jason
Column AC4 95 - Ashlie
Column AC5 94-472 - Ashlie
Column AC6 94-471 - Zach


Thank you!
Tina

Oh my gosh................this is working for the most part.................THANK YOU!!!! I do have one thing that I can't get to work. Along with the 94, I have 94-851 series that I also need to pull up under Zach. Is this able to be added into the formula?