Hello, thanks for responding so quickly.

The vlookup formula is

=VLOOKUP(M2,'Code book'!A:G,'Code book'!A1,2)

There are two sheets in the workbook. The first 'transcript' sheet contains the vlookup function and the codebook sheet contains the value I want to lookup