Thanks guys!
I had setup my exchange rate table the way you see it due to the way I need to setup my google sheet to automatically grab the data. (Ie, 1 row per day - I’ve made a little script to just add a row to the google sheet once every day)
I can def see that its possible to re-work it to grab the data using the new schema, although its a little more complex than the current method of just adding a new row to the document at a certain time every day, and then 5 mins later sending that same data straight to coda using zapier. It also might interfere with some of the ideas I’ve had to clean up the data when the google finance formula fails (as it does once per week like clockwork with the USD rates on sundays!)
Appreciate the help. I’m going to have a fiddle and will report back. Cheers!