Having trouble trying to figure this out

Davisg9

New Member
Joined
Dec 14, 2020
Messages
3
Office Version
  1. 365
Platform
  1. MacOS
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??
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Davisg9

New Member
Joined
Dec 14, 2020
Messages
3
Office Version
  1. 365
Platform
  1. MacOS
See image below
 

Attachments

  • Screen Shot 2020-12-14 at 3.46.11 PM.png
    Screen Shot 2020-12-14 at 3.46.11 PM.png
    44.2 KB · Views: 3

Watch MrExcel Video

Forum statistics

Threads
1,127,753
Messages
5,626,667
Members
416,199
Latest member
Gautamsunil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top