G’day all, I have a file (PostCodes) in which column A has the postcode and column B the city. I a different spreadsheet (customers) I want to enter the postcode and have the city value entered directly into the adjacent cell. Thankyou Harry.