Index/Match, Nest IFs, or something else

[The Grim Discovery]

People

Looking for a bit of general guidance here.
In Col A I've got several thousand rows of data in the form of football team names. There are about 250 individual teams/strings in total. They all appear in Col A many times. I need to match each occurrence with their nationality in Col B. Is there a quick way of doing this? I don't think I can nest enough IFs and I cant see how Index/Match is of help. My knowledge doesn't stretch beyond this. If someone could suggest a technique for me to try/follow, I'd be grateful.


[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Barca[/TD]
[TD]Spain[/TD]
[TD]more stuff[/TD]
[/TR]
[TR]
[TD]PSG[/TD]
[TD]France[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chelsea[/TD]
[TD]England[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Juve[/TD]
[TD]Italy[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bayern[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Real[/TD]
[TD]Spain[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dortmund[/TD]
[TD]Germany[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barca[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[JackDanIce]

Not enough detail to suggest a solution I'm afraid.

You have teams in column A.
Do you have values or formulae in column B?

If formula, what is it?
Do you have a table that maps each team to it's nationality? If so, where is it? If not, why not use a VLOOKUP to this table to map each team to its nationality?

You need to bear in mind only you can see your screen infront of you, the more precise and specific details you provide without any unnecessary commentary (e.g. sheet name, cell addresses), the easier it is to suggest a solution.

 

[Special-K99]

"I need to match each occurrence with their nationality in Col B"

Do you mean values in column A appear in column B, is that right?
It doesnt look like it from the data.
We're talking about all the information being on ONE sheet only aren't we?

Please explain more especially how you're going to match each team with its nationality.

 

[The Grim Discovery]

Thanks for the advice people. Noted.
Bonjourno.

 

[The Grim Discovery]

Thanks for taking the time to dislike my request for help JackDanIce. It's the first negative experience I've had during two years of occasional use of this message board where I've always found support and advice. Charmless oik.