excel formula help - IndexMatch/Vlookup

[Mallesh23]

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.

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

 

[JoeMo]

Book1.xlsm
	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	#N/A
4	672	222	8000		222	672	8000
Sheet3

Cell Formulas
Range	Formula
G2:G4	G2	=INDEX($C$2:$C$4,MATCH($F2&"|"&$E2,$A$2:$A$4&"|"&$B$2:$B$4,0))

 

[mrshl9898]

*better solution above

 

[Mallesh23]

HI JoeMo,

Thanks for your help, I tried your code , but its not working in my case.

Book7
	A	B	C	D	E	F	G
1	Invoice	Ticket	Amount		Ticket	Invoice	Expected Output
2	678	111	5000		111	678	#VALUE!
3	675	333	1000		444	675	#VALUE!
4	672	222	8000		222	672	#VALUE!
Sheet1

Cell Formulas
Range	Formula
G2:G4	G2	=INDEX($C$2:$C$4,MATCH($F2&"|"&$E2,$A$2:$A$4&"|"&$B$2:$B$4,0))

Thanks
mg

 

[Mallesh23]

Hi JoeMo,

Thanks for your help it worked, thanks. ?

Used CTRL + SHIFT + ENTER


Thanks
mg

 

[JoeMo]

Hi JoeMo,

Thanks for your help it worked, thanks. ?

Used CTRL + SHIFT + ENTER


Thanks
mg

Glad you caught that Excel 2010 requires ctrl+shift+enter. I recently switched from 2010 to 365 which requires only Enter