Forum Discussion
Solved
vlookup in stockhistory table
hi all, i want to create a sheet that follows some stocks and tells me every stock when it was at the highes price since it was added to the sheet. for that i'm using vlookup that works on a table f...
will it work without physically showing the table?
Yes
=LET(stock,STOCKHISTORY("msft",TODAY()-90,TODAY(),0,2,0,3),INDEX(stock,XMATCH(10000000000,INDEX(stock,,2),-1),{1,2}))