Hello,

New to the forum – thanks for having me!

I’d be super grateful if someone could help me with a solution to the following problem -

I’ve a set of personal data (UK). I have a column containing location - ‘County’ data - around 90 options (Essex, Lancashire, Merseyside etc). For around 100,000 rows of data – people.

We didn’t collect region data for each of the people – North West, North East, Greater London etc.

I’d like to add a region column and am looking for a solution to auto fill values rather than manually add across the 100,000 entries.

I have a separate worksheet with all 90 of the ‘counties’ in column A, and their corresponding region in column B.

example.PNG

I guess I’m looking for a formula for ‘Worksheet 1’ C2 (new region column), that does something like:

Look in Column B2 (county), if the value matches any of the values in Worksheet 2 Column A (county), Place the value that’s in the column next to it – B (region) - here.

Thanks,
Lee