Dependent dropdown formula not working and I can't see why

I have a Teams column in which values are chosen from a dropdown. Depending on the selected value, I want the neighbouring column to offer a dropdown containing only the names of the members of the selected team.
All the Team names for column D and the names of the people in each team are all in a table on another sheet called 'Meta'.

I followed a video by Leila Gharani on YouTube. The silly thing is I have followed this video before and not had any problems with the formula:

=OFFSET(Meta!$G$9,1,MATCH($D4,Meta!G$9$:T$9$,0)-1,19,1)

As far as I can tell the problem is arising because this time the values in Meta!G$9$:T$9$ are in turn referenced values from other tables. For example, the value in Meta!G9 is "='V4V Teams'!E4". I guess that my OFFSET formula is unable to use the result of the formula in Meta!G9. But is this really so?

Is there any way around this without redoing my Meta table?

EDIT: after getting repeated errors whenever I tried to enter the formula in Data Validation (such that I had to cancel out). The dependent column is now working properly, and I have changed nothing. As far as I could tell, Data Validation had rejected my formula...

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.