Genius ! Yes that will work I am sure - I’ll test it out but yes it does look like the solution.
So would this have to be done in the profile page or another sheet?
not sure I understand this part you could use that sheet in Glide and then be able to return instant results with a template/relation/lookup column combination. but I’ll play with it.
No, I’d have that in a separate sheet.
I have a copy of your app, if I have some time tomorrow I’ll add some dummy data and make an example for you.
You are a STAR !
I’ve got it working a bit - but still having problems getting the data out.
I have a sheet with fixed data from 1999 - 2021 in a column with the rates along side.
I then created a sheet in Glide that uses a relationship to the sheet and then a lookup up to the same.
The data was not individual.
I then tried again with user-specific columns for date and value no good
Then I used the user profile again with relationship and lookup. It worked on the first name in the list but it does not populate down the page with the relationship and lookup so the calculations do not work.
I do feel that I am closer yet mile away!
Thanks
@baremeter @Mike_Greene - here is a copy of your app with a worked example, as promised.
Take a look at the Historical Rates Google Sheet, Glide Table and screen tab
Notes:
- I just added dummy data for the years 2018 to 2021 in order to demonstrate how it works
- The values in the Year & Month choice components are dynamically generated, based on the data values. Check the following columns to see how that works:
- the way it works:
- the selected year and month go into user specific columns (
usc/yearandusc/month) - these are combined in a template (
tp/selected) - this template is used to form a relation to the actual data (
tp/year-month) - a lookup (
lk/selected) retrieves the rate through that relation for the selected year/month combination - the lookup value is combined with the selected year/month values into a template, and that is displayed in a hint component
- the selected year and month go into user specific columns (
Let me know if you have any questions.
Enjoy 
PS. I’ve removed all the personal data that was in the original copy that you shared with me 
2 Likes
My goodness - you have worked so hard on this
I am so very grateful -
I will replicate it in my working version and add in my display features and correct rates data
Just a pity that I cannot copy and paste the Glide Table !
1 Like
hehe, not really. I do this sort of thing a lot, so I’ve had plenty of practice. It might look like a lot of work, but that only took about 20 mins 
Anyway, you’re welcome - hope it gives you a few new ideas to play with.