Formula required, I presume its iNdex match

[Aby]

File attached below.
need the country names when fruit names and code matches according to table

 

[Hui]

C10: =INDEX($B$1:$D$1,1,MATCH($B10,OFFSET($B$1:$D$1,MATCH($A10,$A$2:$A$4,0),),0))

Copy down

 

[Aby]

thanks Hui, working perfect

 

[bines53]

Hello friends ,

Solution without volatile ,and without array,

=INDEX($A$1:$D$1,0,AGGREGATE(14,6,COLUMN($A$2:$D$2)/MMULT({1,1,1},--($A$2:$D$4=A10)+($A$2:$D$4=B10)),1))

David

 

[bosco_yip]

Used simple INDEX/MATCH function for 2 ways Lookup :

=INDEX(B$1:D$1,1,MATCH(B10,INDEX(B$2:D$4,MATCH(A10,A$2:A$4,0),0),0))

Copy down

Regards
Bosco

 

[John Jairo V]

¡Hi to all!

Just for fun... another option:
=INDEX(B$1:D$1,SUMPRODUCT((A10&B10=A$2:A$4&B$2:D$4)*{1,2,3}))

¡Blessings!

 

[Aby]

thanks for the awesome different ways.. all are working... the simplest and also the complex ones