Hi guys,

Just started out on getting into the depths of excel and need some help please!

I have two spreadsheets:

One has a list of around 2000 towns around the UK (Column Q, sheet 1) , the other is a list of ALL towns in the UK (Column A, sheet 2) with corresponding counties next to them (Column B, sheet 2).

I'm looking for a formula that will compare the towns in sheet one with those in sheet 2 and where there are matches, transfer the counties from sheet 2 into sheet 1.

I've looked all over but am hitting a brick wall!

Please help!!!

Thanks in advance

Beatnik10