Simple Find Values?

Ok so I got a cell value and I want to check if it exists in another table. Problem is the second table splits the value and moves the last 2 chars on the right into the next column like this :

4112JJPV

4112JJ PV



Ive tried using vlookup with a LEFT(cell1,6)
and a RIGHT(cell1,2) in place of other values but im having no luck.

I need to check for the first 6 characters then if the next column the value is equal to the last 2 character on the right I would like a True value returned.

I eve tried IF(AND(COUNTIF( but im just getting errors ect

any help please??


Thanks - James