Trouble with getting a function to get a variable cell data

[namesjota]

I'm trying to pull data from a table, i can if i pull them manually, but i wanted to pull three rows changing only one, but all i do, i get the same error.
i tried many ways, but i'm stucked at this, i want to simplicate it, but i'm really stuck at it, so if i cant get it to work, i think it would be hard to get going.

i'm using google sheets and thats a example of what i'm trying to do, the functions pull what i want, but if i get the variable, it gets a error. when i try each piece separately, it works, but as one, it fails.

 

[Peter_SSs]

Welcome to the MrExcel board!

i'm using google sheets

So I have moved your question to the forum for Google Sheets.

 

[namesjota]

am i doing something that's impossible?
i would appreciate some other way to do that