Hello,
I am trying to extract a value from a list that has a data range and a parameter (ie color)
<tbody>
</tbody>
Considering I am entering the color under cell F6 and the date under cell G6, I am using the following formula but not getting the correct answer:
{=INDEX($D$1:$D$3,MATCH(1,IF(G6>=$A$1:$A$3,IF(G6<=$B$1:$B$3,IF(F6=$C$1:$C$3,1)),0)))}
Your help is really appreciated!
I am trying to extract a value from a list that has a data range and a parameter (ie color)
A | B | C | D | |
1 | 1-Jan-19 | 28-Feb-19 | Red | Value 1 |
2 | 1-Mar-19 | 31-Mar-19 | Red | Value 2 |
3 | 1-Jan-19 | 31-Mar-19 | Blue | Value 3 |
<tbody>
</tbody>
Considering I am entering the color under cell F6 and the date under cell G6, I am using the following formula but not getting the correct answer:
{=INDEX($D$1:$D$3,MATCH(1,IF(G6>=$A$1:$A$3,IF(G6<=$B$1:$B$3,IF(F6=$C$1:$C$3,1)),0)))}
Your help is really appreciated!