I am trying to use
=GOOGLEFINANCE(B2, "high", DATE(2022,7,26)).
According to google's docs, using historical values in this formula will result in an array result...
So, it pumps values all around my table, kinda ruining what I am trying to do:
Date High 44768.67 105.13
(all of the above should be just one cell, but the formula results in splatting 4 cells, as array formulas do)
What I need is to get the number
105.13 but I don't have any leads on how to do that. I tried looking into
join() but it seems my use case is not common enough for me to find relevant discussion and/or examples.
Any tips appreciated :)