[Matthew]

I have got a spreadsheet which had a lot of data in but would like to use some sort of lookup table to help out.

In column H I have a location i.e. town/village and I have a column (C) which has had one of 38 codes put in. When a location is put into column H I want it to refer to a seperate sheet and then enter the code in column C.

The seperate sheet is has 2 columns, one (A) location and then B which is the code.

At the minute there are only 38 enteries into this seperate sheet but there will be others as I get around to adding them.

Can anyone help on this?

By the way the sheet will have around 32k lines of data in by the end of the year so it will be a big time saver if there is a formula that can do some of the work.

Cheers