The Company Codes on Profit & CC sheet are numbers whereas on your Journal sheet they are text (Col B) - you must coerce Col B in the VLOOKUP such that the data type matches, eg:

=IF(N4=470300,VLOOKUP(B4+0,'Profit and Cost Centres'!$A$2:$C$142,2,0),"")