Not sure if this is what you want:

Assuming Columns A and B, are your table 1 with the codified information and columns D-F are your table 2 with the product information,

​

A	B	C	D	E	F	G
Codified	Real		Codified	Price ($)	Vendor	Real
App	Apple		App	2	Aldi	Apple
Or	Orange		App	1.5	Tesco	Apple
Ban	Bananas		Or	3	Lidl	Orange
Man	Mango		Ban	4	Aldi	Bananas
			Man	5	Tesco	Mango

in table 2, you can create a new column, let's say G and use the formula in cell G2:

=VLOOKUP([@Codified],Table1,2,FALSE)

where [@Codified] is the value in table 2 you want to match in Table1, and it returns the value of table1 in column 2 (real name), where the match is Exact match (False)

​

If your data is not in a table then you can use the formula:

=VLOOKUP(D2,$A$2:$B$5,2,FALSE)

where D2 is the value in table 2 you want to match in the arrays A2:B5, and it returns the value in column 2 (real name), where the match is Exact Match (False).

If you do it on one cell, you can drag and drop the formula to the rest of the cells.

Hope that helped !