Having trouble trying to figure this out

[Davisg9]

I am trying to figure a way that I can make this work in excel google sheets. I have this formula that will look up a specific value in say C36 and I am wanting to be able to type in a stock symbol in A36 that will plug into this formula where it is =aapl

Cell C36:
=IMPORTXML("FINVIZ.com - Stock Screeneraapl","/html/body/div[4]/div/table[2]/tbody/tr[8]/td[12]/b")


Example:
A36 say would equal TSLA and then the formula in C36 would give me the value for TLSA (the equal part in this formula would =TSLA).

Any thoughts on how to make this work??

 

[Davisg9]

See image below