Hi Team,
Need your help , Please suggest formula
Below is a Table, Column A,B,C are input data, Expected output is my G Column.
By Combining ticket and Invoice column I want output in Column G Column. how to use vlookup or index match or any other formula.
Thanks in advance for help!
Thanks
mg
Need your help , Please suggest formula
Below is a Table, Column A,B,C are input data, Expected output is my G Column.
By Combining ticket and Invoice column I want output in Column G Column. how to use vlookup or index match or any other formula.
Book7 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Invoice | Ticket | Amount | Ticket | Invoice | Expected Output | |||
2 | 678 | 111 | 5000 | 111 | 678 | 5000 | |||
3 | 675 | 333 | 1000 | 444 | 675 | not found | |||
4 | 672 | 222 | 8000 | 222 | 672 | 8000 | |||
Sheet1 |
Thanks in advance for help!
Thanks
mg