Conditional formatting with INDEX & MATCH

[Mazbuka]

I'm learning INDEX/MATCH & have a little problem with conditional formatting

Below example looking at air fares by airline to various destinations, in cell D10 I return the correct cost based on the selections of airline & destination in B10 & C10, it works fine:

=INDEX($B$3:$F$7,MATCH($B$10,$A$3:$A$7,0),MATCH($C$10,$B$2:$F$2,0))


However, if I want to apply conditional formatting to B3:F7 and use the same formula, so starting at B3 and pasting format down & across to F7

=B3=INDEX($B$3:$F$7,MATCH($B$10,$A$3:$A$7,0),MATCH($C$10,$B$2:$F$2,0))

As F4 & F7 have the same cost, each are highlighted when my selection is Amsterdam & Qantas (or Manchester & Qantas) as it's fomatting based on the result, 1,896...

How do I get it to only format the cell at the selected intersection?

1	A	B	C	D	E	F
2		ETIHAD	BA	AIR FRANCE	EMIRATES	QANTAS
3	DUBLIN	1,850	1,733	1,800	1,955	2,013
4	MANCHESTER	1,974	1,712	1,936	1,821	1,896
5	LONDON	1,723	2,003	2,002	2,112	1,982
6	PARIS	1,715	1,814	2,021	1,888	2,061
7	AMSTERDAM	2,053	2,012	1,743	2,114	1,896
8
9		FLY TO	AIRLINE	COST
10		AMSTERDAM	QANTAS	1,896

<tbody>
</tbody>

 

[ClaireS]

I think you're getting over-complicated with INDEX/Match. This seems to work fine for me:

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=AND($A3=$B$10,B$2=$C$10)[/FONT]

 

[Mazbuka]

Ha, that was really a case of me not seeing the woods for the trees! Such a simple fix, thanks Claire.

 

[ClaireS]

Happy to help