formula help 1

[HOMMER]

a5=1 d5=6
a10=2 d10=7
a15=3 d15=8
a20=4 d20=9
a25=5 d25=10


i want a formula that does this.
if i put a number in cell e5 it will look at the list find that number and display the contents of the cell two above the one it found.
like this.


cell e5=6
the formula will display cell d3 contents

cell e5=9
the formula will display cell d18 contents

cell e5=5
the formula will display cell a23 contents

etc, etc, etc.

 

[DarkSun]

As long as you dont move the data you can use this:

=IF(E5<=5,INDIRECT(&quot;A&quot; &(E5*5-2)),INDIRECT(&quot;D&quot; &((E5-5)*5-2)))

I could explain it if you want.