Formula help

[Hiport]

Hi

I need a formula that will return value in Col C based on the data in Col E-G

Sheet1

*	A	B	C	D	E	F	G
1	Test1	Test2	Result	*	Mapping	*	*
2	Apple	Yellow	Lucy	*	Apple	Yellow	lucy
3	Pear	Red	*	*	water	red	lucy
4	bear	blue	*	*	banana	red	lucy
5	water	red	Lucy	*	*	*	*
6	banana	red	Lucy	*	*	*	*
7	strawberry	black	*	*	*	*	*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Thanks
Excel tables to the web >> Excel Jeanie HTML 4

 

[AlanY]

try this

Excel 2012
	A	B	C	D	E	F	G
1	Test1	Test2	Result		Mapping
2	Apple	Yellow	lucy		Apple	Yellow	lucy
3	Pear	Red			water	red	lucy
4	bear	blue			banana	red	lucy
5	water	red	lucy
6	banana	red	lucy
7	strawberry	black
Sheet8

Cell Formulas
Range	Formula
C2	{=IFERROR(INDEX($G$2:$G$7,MATCH(A2&"/"&B2,$E$2:$E$7&"/"&$F$2:$F$7,0)),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Hiport]

Thank you!

 

[AlanY]

you're welcome