Find a match; compare corresponding cells; and return value from a third cell

Hello All,

I want to achieve something as stated below.

Basically, I have 5 columns. I want to find a match for A2 in column D; compare value in column E returned by INDEX function with value in B2 (cell against A2, which is being matched); and return value from column F (same row where match has been found), if the comparison criterion is satisfied. Please see the file attached.

I have been trying below formula. However, it does not work, for obvious reasons (not known to me).

=if(AND(INDEX(E:E,MATCH(A2,D:D)>0.9*B2),INDEX(E:E,MATCH(A2,D:D)<1.1*B2)),Return Value from Column F,"No")

Any help, please.