Infill data from another file

[eleee3]

Hi,

I have a database that looks something like this:

Item	Code	Code Description
Apples	RED
Bananas	YEL
Oranges	ORA
Pineapples	YEL
Persimmons	ORA
Plum	PUR

I then have a dictionary which looks like this:

Code	Definition
RED	Red
YEL	Yellow
ORA	Orange
PUR	Purple

I want to look up my dictionary to infill my main database such that it will look like this:

Item	Code	Code Description
Apples	RED	Red
Bananas	YEL	Yellow
Oranges	ORA	Orange
Pineapples	YEL	Yellow
Persimmons	ORA	Orange
Plum	PUR	Purple

Could someone please help me do this?

Note the dictionary and database are in two separate files.

Thanks in advance!

[ShankerV · Accepted solution]

Hi @eleee3 

.

This can be achieved with the help of Find and Replace tool.

Many thanks

Shanker V