Period 0-7 41852 15-21 22-28
Value Time to pay
1000 21 [1000]
500 4 [500]

I am trying to set up a worksheet so that once an individual selects a value
in the Time to pay column, a value will be generated in the relevant period.
I've shown the desired output in square brackets above. I've tried an IF
function but I ultimately end up exceeding the available number of IFs
allowed. I've also tried lookups to no avail.