Excel - grabbing specific data from sheet2 depending on a certain cell in sheet1

Creating a tracking sheet for my investments. I have an API installed that gives live raw market data but not my specific investments. I'm wanting to bring in a column that shows how the assets are performing in a 24 hr period (this data is in sheet2). The data in sheet 2 is constantly changing as it is sorted in Market Cap so depending on how the assets are performing on a given day the data is constantly changing. My list of investments are in sheet 1 and I'm wanting to perform a formula that will be able to grab the correct data from sheet2 and implement it into the correct column in sheet1.

An example:

I want to bring the 24hr % performance from sheet 2 (where the raw data is) of the stock 'AAPL', and insert it next to Sheet1 where I track my investments by the Symbol of the stock: AAPL

For the formula below:

C6 is where I store the SYMBOL (ie "AAPL").

latest[Column1.symbol] is the column in the referred sheet2 to match the symbol.

latest[Column1.quote.USD.percent_change_24h] is the raw data for the 24hr % change of the stock.

I thought it'd be something like :

=IF(ISTEXT(C6),FIND("AAPL",latest[Column1.symbol])(latest[Column1.quote.USD.percent_change_24h]),(""))

Which is apparently a failed formula.

Any help would be greatly appreciated.