Excel Help - Lookups
 

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

Re: Excel Help - Lookups
 

=INDEX(Sheet2!$A$1:$B$3, MATCH(H2,Sheet2!$A$1:$A$3,), MATCH("code",Sheet2!$A$1:$B$1,))

Where Sheet2!$A$1:$B$3 is where your lookup data us held
H2 is your town name and Code is the column you want to pull the values from.

Re: Excel Help - Lookups
 

Cheers for that, I will give it ago later.

Re: Excel Help - Lookups
 

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.