Hi Team,
Below is my data and expected output is in Column G,
By combining column E and F, extract value from Column C,
and criteria is Column D value should be greater than 0.
Below formula works, without conditon of criteria D.
'=INDEX($C$2:$C$4,MATCH($F2&"|"&$E2,$A$2:$A$4&"|"&$B$2:$B$4,0))
Thanks
mg
Below is my data and expected output is in Column G,
By combining column E and F, extract value from Column C,
and criteria is Column D value should be greater than 0.
Below formula works, without conditon of criteria D.
'=INDEX($C$2:$C$4,MATCH($F2&"|"&$E2,$A$2:$A$4&"|"&$B$2:$B$4,0))
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Invoice | Ticket | Amount | xxx | Ticket | Invoice | Expected Output | ||
2 | 678 | 111 | 5000 | 0 | 111 | 678 | - | ||
3 | 675 | 333 | 1000 | 1 | 444 | 675 | - | ||
4 | 672 | 222 | 8000 | 2 | 222 | 672 | 8000 | ||
5 | 671 | 444 | 1000 | 3 | 671 | 444 | 1000 | ||
6 | |||||||||
7 | =INDEX($C$2:$C$4,MATCH($F2&"|"&$E2,$A$2:$A$4&"|"&$B$2:$B$4,0)) | ||||||||
Sheet1 |
Thanks
mg