help with if - index - match

[xtremeusta]

if cell a1 = cell a2, index c1:c10, match b1, d1:d10, and if cell a1 = cell a1, devide the result of the index and match by e1

=IF(A1=A2,INDEX(C1:C10,MATCH(B1,D1:D10,0) ----- i am trying to get the result of this to then IF(A1=A2/D1,0)

is there a way to do this?

would really appreciate anyones help

 

[etaf]

which do you want to test first
BUT Cell A1 will = cell A1 as its itself

what do you want if Cell A2 does not equal A1
or is that what you mean

IF(A1=A2,INDEX(C1:C10,MATCH(B1,D1:D10,0)) , INDEX(C1:C10,MATCH(B1,D1:D10,0)) /D1)
so the false is if A1 does not = A2

we can add more IFs - just not sure what A1=A1 means