Using VLOOKUP to automatically retrieve a name from a separate worksheet using a code

Hi,

I want to use VLOOKUP in in a way that, when I enter a 6digit code in the 'relation' Column, the Customer Name gets retrieved from the 'Customers List and Codes' sheet and placed into the 'Customer' column, to the left of the 6 digit code. Is there a way to do this?

I keep getting N/A error so I'm unsure of what to do.

thanks.