Hi

I am a bit of a noob so please bear with me.

I have two sheets. One contains a list of postcodes in one column and the ward in which these fit into in another column.

The other sheet contains peoples information, one column of which is the postcode. I would like to add to each row the ward they live in.

Sheet 1
Row A is the postcodes Row D is the Ward

Sheet 2
Row A is the postcode Row D is going to be the Ward.

I hope this is enough info, I pretty sure I use the lookup command and can get the Ward if I tell it the specific postcode but Im not sure how to get it to first lookup the postcode, then lookup that postcode in another sheet and then retun the ward.

Hope you can help.

Thx

Dan