I think you had a typo with your first example, since there is no .47 in your data set. But it works if you meant .497. Here's one possibility:
<tbody>
[TD="align: center"]102[/TD]
[TD="align: right"]0.501[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.498[/TD]
[TD="align: right"]0.502[/TD]
[TD="align: center"]103[/TD]
[TD="align: right"]0.499[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]104[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]105[/TD]
[TD="align: right"]0.503[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]106[/TD]
[TD="align: right"]0.498[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]107[/TD]
[TD="align: right"]0.502[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]108[/TD]
[TD="align: right"]0.499[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]109[/TD]
[TD="align: right"]0.502[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]110[/TD]
[TD="align: right"]0.498[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]111[/TD]
[TD="align: right"]0.497[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]112[/TD]
[TD="align: right"]0.497[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]113[/TD]
[TD="align: right"]0.498[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]114[/TD]
[TD="align: right"]0.504[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]115[/TD]
[TD="align: right"]0.497[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]116[/TD]
[TD="align: right"]0.497[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]117[/TD]
[TD="align: right"]0.498[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]118[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]119[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]120[/TD]
[TD="align: right"]0.498[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]121[/TD]
[TD="align: right"]0.502[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>
If entered correctly, Excel will surround with curly braces {}.
One quirk: if you enter a number in Q102 that is not in the N102:N121 list, then it will return the value in N1.
Let me know how this works.