Hello,
I am trying to extract a value from a list that has a data range and a parameter (ie color)
<tbody>
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>
Considering I am entering the color under cell F6 and the...