Populate column for list of towns

Hi

thanks for the reply.

Yes they are duplicated throughout.

e.g. a list such as:


london
cheltenham
london
london
cheltenham
leeds
leeds
cheltenham
glasgow
glasgow

I have tried the formula and it works but it brings up a #N/A message if the names are duplicated?

Can you help or guide me as to what I am doing wrong please?

Your lookup table should include each name and area only once. Also if you are populating the formula with autofill what your range, as it will move it down automatically.

So if your lookup table has london on top, and your initial range was A1:B2 in the formula and you autofill, range in the second formula will be A2:B3, so you need to make the range an absolute reference so that it still sees London at the top.

Cheers,
Justin

OK, Thanks, But I am a little confused, sorry.

I have included the file I am working on, I have simply created votes data.

Can you please check it and see what is wrong please?