Looking up data between two sheets and auto filling a field

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

Hi,

Try the following formula in Sheet1! P2 or R2:

=VLOOKUP(Q2,Sheet2!A:B,2,0)

Hopefully i've attached a sample.

The list i have is of 7000 town names, 5000 already had counties so i've just filtered my list to those without - whether that matters i don't know!

Thanks again

In B2 (Sheet1!):

=VLOOKUP(A2,Sheet2!A:B,2,0)

Fantastic! Great stuff!!

Quite a few blanks but that'll just be because they arn't mentioned on sheet2.

If you wouldn't mind, could you give a brief breakdown of that formula so i can understand which bit is doing what?

Quite a newbie at this so just trying to learn as i go!

again, thankyou!

=VLOOKUP(A2,Sheet2!A:B,2,0)

In this case VLOOKUP function picks up the content from cell A2 (Sheet1!) and looks for a match in Column A (Sheet2!). Once a match is found, it returns the content from column B from the same row.


Please go through the following URL for details on VLOOKUP function:

https://support.office.com/en-in/art...8-93a18ad188a1

Legend!

Thank you

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.