Formula needed to save manual input

Hello.
In any given set of fixtures, I want to enter each home team in column X and each away the team in column Y.
Is there a way to have the Home Strength calculation show in columns Z and the Away Strength calculation show in columns AA without having to do it manually?

Each home team's strength number is determined by multiplying the home attacking strength (HAS) in column T with the away defensive strength (ADS) in column W with Cell H30 (T*W*H30)
Each away team's strength is worked out by multiplying the away attacking strength (AAS) in column V with the home defensive strength (HDS) in column U with Cell Q30 (V*U*Q30)

Thank you.

Thank you for a very prompt reply. I'll try your formula for HAS and ADS and then figure out what the formula for HDS and AAS will be. Hopefully by then, I'll be able to understand the formula for AA. Thanks again for your help and I'll post the outcome in this thread.

Ok. Before I go any further, I need to point something out. Taking Maidenhead as an example, the HAS for Maidenhead when using the calculation =H7/$H$30, produces the number 1.61
However, using your formula, the HAS for Maidenhead produces the number 1.24 when using =VLOOKUP(X7, $A$7:$T$28,20, 0)

Ok, I'm playing around with the formula and now realise that when applied to column Z, both formulas produce the same result. Later, I'll be trying a formula for column AA.
Thank you.

I tried a few ways but they all gave me a #REF! error. Here are a couple I tried:
=VLOOKUP(Y7, $A$7:$U$28,20, 0)*VLOOKUP(X7, $A$7:$V$28, 23, 0)*$Q$30
=VLOOKUP(Y7, $A$7:$V$28,20, 0)*VLOOKUP(Y7, $A$7:$U$28, 23, 0)*$Q$30

I was trying to use your formula for Z7 to work it out but kept hitting a dead end.
Thank you so much for the final solution, it'll save me hours of time doing it manually. (I usually work out the ratings for as many as 7 different leagues during the week for the weekend fixtures.)
It'll also help me to wok out any future formulas I might try to implement in the future.