Auto Fill information from value table
I believe this can be done somehow with a lookup but I can't quite figure it out?
Tracking project investments made in the past and insert CPI for calculations later..., so the idea is you enter the year built and both the year and the related CPI (which are matched up in a value table) to show up in fields in the table.
This is similar to being able to type in a zipcode and the state auto populating or something similar?
Any help would be appreciated