This is PN reddy

Hello. I am a new comer that facing problems with MS Excel formula .
Hopefully all the expert in this forum community can help me. Thank you.

Hai,
Please do support to solve this excel sheet. In the attached demo sheet Table-1 having data need to match and with Table-2 ID, need to check with Track number First 2 Characters then count in Count of PE column. Similarly Count of DP. Now,next column need to display first date of PE, then next column last date of DP.
By using Vlookup or Match, countif, if functions. or you can use which is the best in your idea to solve this

Thank you