A | B | C | D | E | F | G | |
1 | DATE | FROM | TO | PRICE | |||
2 | 01-03-18 | A | Z | 18,900 | |||
3 | 10-03-18 | A | Z | 18,500 | DATE : | ||
4 | 29-03-18 | B | Z | 18,900 | FROM : | ||
5 | 11-04-18 | A | Z | TO : | |||
6 | 18-04-18 | A | Z | 19,500 | RESULT : | ||
7 | 18-04-18 | B | Z | 19,800 | |||
8 | 26-04-18 | A | Z | ||||
9 | 27-04-18 | A | Y | ||||
10 | 27-04-18 | B | Y |
<tbody>
</tbody>
HI, I want to extract result (G6) that would skip empty cell if I input data DATE (G3), FROM (G4), TO (G5) for examples:
EX1:
DATE : 26-04-18
FROM : A
TO : Z
RESULT : 19,500 (D6)
EX2:
DATE : 12-04-18
FROM : A
TO : Z
RESULT : 18,500 (D3)
Sorry for my bad English
Thank you so much