Hi,
Any help on this really appreciated as I'm totally at a loss:
What I want to do:
C3 is dependent on - level entered in a3 is between x =y, and if b3 is less than f1 enter corresponding value in column F, or if more than f1 enter value from column G from the table e3:g7
So in this example I would want the value returned to be 13 (value is in the 130 range and date is before f1)
Thanks
Any help on this really appreciated as I'm totally at a loss:
A | B | C | D | E | F | G |
31/12/2017 | ||||||
Level | Date | Value | Level | Value1 | Value2 | |
135 | 23/05/2016 | 120 | 12 | 13 | ||
130 | 13 | 14 | ||||
140 | 14 | 15 | ||||
150 | 15 | 16 | ||||
160 | 16 | 17 |
What I want to do:
C3 is dependent on - level entered in a3 is between x =y, and if b3 is less than f1 enter corresponding value in column F, or if more than f1 enter value from column G from the table e3:g7
So in this example I would want the value returned to be 13 (value is in the 130 range and date is before f1)
Thanks