Comparing two sheets values and return the header

[AniSaikia]

Hi All,
Good Afternoon,

I need to compare Sheet 1
[TABLE="width: 86"]
<colgroup><col></colgroup><tbody>[TR]
[TD]SLA [/TD]
[/TR]
[TR]
[TD]111[/TD]
[/TR]
[TR]
[TD]221[/TD]
[/TR]
[TR]
[TD]333[/TD]
[/TR]
[TR]
[TD]with Sheet 2 below table
[TABLE="width: 305"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Gold[/TD]
[TD]Silver[/TD]
[TD]Bronze[/TD]
[/TR]
[TR]
[TD="align: right"]311[/TD]
[TD="align: right"]211[/TD]
[TD="align: right"]111[/TD]
[/TR]
[TR]
[TD="align: right"]312[/TD]
[TD="align: right"]212[/TD]
[TD="align: right"]112[/TD]
[/TR]
[TR]
[TD="align: right"]313[/TD]
[TD="align: right"]213[/TD]
[TD="align: right"]113[/TD]
[/TR]
[TR]
[TD="align: right"]321[/TD]
[TD="align: right"]221[/TD]
[TD="align: right"]121[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
And return value like GOLD, Silver or Bronze

Suppose Sheet 1 111 = Sheet 2 111 , then result should be Bronze

Thanks in advance

 

[AniSaikia]

Please suggest

 

[AniSaikia]

I m trying this kind of formula but not working

=INDEX(SetUp!$L$1:$N$1,MATCH(Master!AU2,SetUp!$L$2:$N$10,0))

 

[FormR]

Please suggest

Hi, you should be waiting a lot longer than 15 minutes before bumping your threads - you risk putting people of replying if you are too eager, especially as many people use the "posts with zero replies" option when looking for questions to help with.

That said, here is one option you can try:

Excel 2013/2016
	A	B
1	SLA	Result
2	111	Bronze
3	221	Silver
4	333	#NUM!
5	312	Gold
Sheet1

Cell Formulas
Range	Formula
B2	=INDEX(Sheet2!$A$1:$C$1,AGGREGATE(14,6,COLUMN(Sheet2!$A$1:$C$1)/(Sheet2!$A$2:$C$5=A2),1))

Excel 2013/2016
	A	B	C
1	Gold	Silver	Bronze
2	311	211	111
3	312	212	112
4	313	213	113
5	321	221	121
Sheet2