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")
**** Look at the image for the formula****

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??

 

[Fluff]

Duplicate Having trouble trying to figure this out

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).