PLEASE GIVE ME FORMULA for B2 Raw

[Jagat Pavasia]

[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]120
[/TD]
[TD]100.25
[/TD]
[TD][/TD]
[TD]120
[/TD]
[TD]100.25
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]121
[/TD]
[TD]1403.25
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]122
[/TD]
[TD]1007.98
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]123
[/TD]
[TD]500.25
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]124
[/TD]
[TD]266.63
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]125
[/TD]
[TD]985.23
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]126
[/TD]
[TD]2.30
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The Raw "D" have Number from D2 TO D100
and Raw "E" have Weight from E2 to E100

If I type in A1 then B1 should have answer from E.

For Example : My answer in B1 is 100.25
If I Type 125 in A1 the answer should be 985.23 in B1.


Please give me formula..

waiting..

 

[JoeMo]

In B1: =IF($A1="","",VLOOKUP($A1,$D$2:$E$100,2,0))