Add ‘country name’ column to worksheet from a list of country codes.

Hi all,

I've got a worksheet with five columns of data.

One of the columns contains country codes.

I have a list of countries that the codes relate to.

I would like a new column in the worksheet that contains the country name.

I'm not sure if this is possible, but it seem that most things are with VBA!

The countries and their codes are on 'Sheet2'

I relalise I might have to do some boring re-ordering of the data on 'Sheet2'

I enclose example dataset.

Thanks for any suggestions!

Ben

Use this formula in F2:

=INDEX(Sheet2!A:A,MATCH(Sheet1!A2,Sheet2!B:B,0))

and copy it down the column