Untitled

 avatar
unknown
javascript
2 years ago
182 B
4
Indexable
=makearray(counta(A2:A),counta(B1:1),lambda(r,c,let(row,index(A2:A,r),col,index(B1:1,c),
          if(col="CMP",googlefinance(row),ifna(index(googlefinance(row,"price",col),2,2))))))
Editor is loading...