I want to match first six characters of "Lookup Value" with the first six character of the "Table-Array" and could not write the formulae.
The first portion LEFT($A22,6) worked fine, it reads the first six character of the Lookup value, but the second portion (LEFT('UZA-MPO'!$E$2:$P$500,6) is not working. I think I am not writing it correctly. Please help me.
Best!

=IF(A22="","-",VLOOKUP(LEFT($A22,6),LEFT('UZA-MPO'!$E$2:$P$500,6),2,FALSE))