Index and match help

[bluefeather8989]

=INDEX(E1:E11,MATCH(9,C1:C11))

in A1


C E
9 11
9 22
9 33
9 44
9 55
9 66

if i use the code as is then in A1 i should get 66 as my answer
how do reverse this so my answer would be 11?

 

[hiker95]

bluefeather8989,

Try:

Excel Workbook
	A	B	C	D	E
1	11		9		11
2			9		22
3			9		33
4			9		44
5			9		55
6			9		66
7
8
9
10
11
Sheet1