Pick and Choose

[sj1601]

I have a list of all the countrys' codes (column). I have a list of 17 countries that I am interested in which has to show up on my report.

How can I create a dynamic formula to pick up these 17 names from this list?

Thanks.

sj1601

 

[Domenic]

We do not have a list for the Country Names we want in the given data. (Should we create one?

Yes, you'll need to set a table to which the formula refers. So, for example, let A1:A17 contain a list of the country codes, and B1:B17 a list of the corresonding country names. Then, with your list of codes in D1:D10000, enter the following formula in E1, and copy down:

=INDEX($B$1:$B$17,MATCH(D1,$A$1:$A$17,0))

Hope this helps!

 

[sj1601]

Thanks Domenic. I used the vlookup function and I have the desired output now.

Maybe in the future I will need to tweak it a bit more to make it more dynamic so that I can eliminate repetitive steps.

Thanks everyone for your help.

Have a great weekend.