Bright01
asked on
Creating a Value in an Array
EE Pros,
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,
Bright01
C--Data-Temp-Finding-the-Frequency.xls
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,
Bright01
C--Data-Temp-Finding-the-Frequency.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Glenn, Perfect. Thank you very much!
B.
B.
You're welcome.
-Glenn
-Glenn
Write the following formula in D4
=OFFSET($N$5, E4,E3)
-FA