You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.
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.
For some reason that hasnt worked. I am going to have a play over the weekend to see if I can but when I tried it tonight it wouldnt work. I guess its something simple but after a long day today I've left it.
Join CF
You are here: 
