I'm working to produce a data table based on two variables; Time Horizon and Frequency. Both are time variables. You can see in the spreadsheet I provided that by selecting a Horizon and a Frequency, it returns a value that then corresponds to a table. Here's my challenge, how do I use a lookup formula to determine the number to multiply with? Once the number is determined in the table, it can be multiplied by the Time number (e.g. 3 months) to get a total # of frequency data points to derive (over the given Time Horizon).
Up for the challenge?
Thank you in advance,