Is vlookup the correct function for the result I want?

Hello.
Please find attached my English Premier League Table.
In column AB under Home, I want to enter each home team and have their corresponding Home Attack Strength rating from column W to appear in column AC under Goals.
In column AD under Away, I want to enter each away team and have their corresponding Away Defence Strength rating from column Z to appear in column AE under Goals.
So, if I enter all the home teams in column AB and all the away teams in column AD, all the relevant information will appear under each Goals column.
Thank you.

Please provide a few rows of expected results - it's not clear to me what data you want to see there. I'm not even sure why you want to apparently repeat what is already on the same row.

In AA9 you might use
=IFERROR(INDEX(U$9:U$28,MATCH($Z9,$C$9:$C$28,0)),"")
and copy to AC9.

Please explain what you mean by "doesn't work". I cannot see in the attached workbook that anything is malfunctioning. You are going to need to be more explicit: which values do you think it's getting wrong?

EDIT: I've found the problem: there are trailing spaces. Look at AA34 - there is a space after the word Norwich - that needs to go.

Try this:

=IFERROR(INDEX(V$34:V$57,MATCH(TRIM($AA34),$B$34:B$57,0)),"")

You won't get a match with Bristol City for obvious reasons!

All calculations alongside Premier League tables are working correctly. All other calculations alongside the other tables, are not.

And have you tried my suggestion?

Please don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

To clarify, here's what I said in post #9:

I've found the problem: there are trailing spaces. Look at AA34 - there is a space after the word Norwich - that needs to go.

Try this:

=IFERROR(INDEX(V$34:V$57,MATCH(TRIM($AA34),$B$34:B$57,0)),"")

You won't get a match with Bristol City for obvious reasons!

That appears to work. Thank you very much. Unfortunately, I have to go out for a bit. I'll be back later. Thanks again for your help.

In post #11 I asked you not to quote posts unnecessarily. Please do not ignore a Moderator's request. I have removed the clutter for you once again.

Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.