Thanks Toppers that has worked a treat.

"Toppers" wrote:

Look at VLOOKUP function.

"JLB" wrote:

I have a report coming in the form of a csv file, one of the columns has a
list of values which I need to cross reference against another column of
values in a different worksheet and replace with the second value in the
first worksheet. Is it possible to automate this process via formula etc. or
can it only be done manually? If possible, how do you do it?