I'm very confused on how I can use data blaze to solve this problem. Any help would be appreciated. I'm trying to avoid having to use a very long if/then condition and instead use datablaze to fill from a table.
Essentially, I have this table
I want it to auto fill from a data blaze table I made that looks like this. Where the first column is the SS number and the second number is the output.
I want to be able to inout a number into the SS Phonemic Proficiency text box and have it access the data blaze table, find the output that is associated with that number and insert that number into the percentile rank box. So for example, if I entered 127 as the value for SS Phonemic Proficiency, the ranking box would display 96. For whatever reason, I can't seem to make this work.
Any tips are appreciated, thank you ![]()

