How to create a relationship between a range and individual number from different Tables?

[Mavericks334]

Hi,

I have two seperate tables, one that has individual values and the other has ranges, i need to create a relationship between these two tables to find out where this individual values come under?

Table 1.
[TABLE="width: 89"]
<COLGROUP><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1170" width=32><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1316" width=36><TBODY>[TR]
[TD="class: xl63, width: 32"]Site[/TD]
[TD="class: xl64, width: 50"]Range[/TD]
[TD="class: xl65, width: 36"]Nf Units[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 32, bgcolor: #ebf1de"]HYD[/TD]
[TD="class: xl66, width: 50, bgcolor: #ebf1de"]0 - 0.50[/TD]
[TD="class: xl67, width: 36, bgcolor: #ebf1de"]30[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 32, bgcolor: #ebf1de"]HYD[/TD]
[TD="class: xl66, width: 50, bgcolor: #ebf1de"]0.51 - 0.99[/TD]
[TD="class: xl67, width: 36, bgcolor: #ebf1de"]36[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 32, bgcolor: #ebf1de"]HYD[/TD]
[TD="class: xl66, width: 50, bgcolor: #ebf1de"]1.00 - 1.99[/TD]
[TD="class: xl67, width: 36, bgcolor: #ebf1de"]41[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 32, bgcolor: #ebf1de"]HYD[/TD]
[TD="class: xl66, width: 50, bgcolor: #ebf1de"]>1.99[/TD]
[TD="class: xl67, width: 36, bgcolor: #ebf1de"]43[/TD]
[/TR]
[TR]
[TD="class: xl68"]POZ[/TD]
[TD="class: xl70, width: 50, bgcolor: #dce6f1"]0 - 0.50[/TD]
[TD="class: xl69, width: 36, bgcolor: #dce6f1"]28[/TD]
[/TR]
[TR]
[TD="class: xl68"]POZ[/TD]
[TD="class: xl70, width: 50, bgcolor: #dce6f1"]0.51 - 0.99[/TD]
[TD="class: xl69, width: 36, bgcolor: #dce6f1"]34[/TD]
[/TR]
[TR]
[TD="class: xl68"]POZ[/TD]
[TD="class: xl70, width: 50, bgcolor: #dce6f1"]1.00 - 1.99[/TD]
[TD="class: xl69, width: 36, bgcolor: #dce6f1"]39[/TD]
[/TR]
[TR]
[TD="class: xl68"]POZ[/TD]
[TD="class: xl70, width: 50, bgcolor: #dce6f1"]>1.99[/TD]
[TD="class: xl69, width: 36, bgcolor: #dce6f1"]41[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 32, bgcolor: #e4dfec"]TOR[/TD]
[TD="class: xl71, width: 50, bgcolor: #e4dfec"]0 - 0.50[/TD]
[TD="class: xl72, width: 36, bgcolor: #e4dfec"]26[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 32, bgcolor: #e4dfec"]TOR[/TD]
[TD="class: xl71, width: 50, bgcolor: #e4dfec"]0.51 - 0.99[/TD]
[TD="class: xl72, width: 36, bgcolor: #e4dfec"]32[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 32, bgcolor: #e4dfec"]TOR[/TD]
[TD="class: xl71, width: 50, bgcolor: #e4dfec"]1.00 - 1.99[/TD]
[TD="class: xl72, width: 36, bgcolor: #e4dfec"]36[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 32, bgcolor: #e4dfec"]TOR[/TD]
[TD="class: xl71, width: 50, bgcolor: #e4dfec"]>1.99[/TD]
[TD="class: xl72, width: 36, bgcolor: #e4dfec"]38[/TD]
[/TR]
</TBODY>[/TABLE]


Table Two.


[TABLE="width: 144"]
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>[TR]
[TD="class: xl65, width: 64, bgcolor: #99ccff"]Site[/TD]
[TD="class: xl65, width: 64, bgcolor: #99ccff"]Name[/TD]
[TD="class: xl65, width: 64, bgcolor: #99ccff"]Score[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: #ebf1de"]HYD[/TD]
[TD="class: xl66, width: 64, bgcolor: #ebf1de"]ABC[/TD]
[TD="class: xl66, width: 64, bgcolor: #ebf1de, align: right"]0.25[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: #ebf1de"]HYD[/TD]
[TD="class: xl66, width: 64, bgcolor: #ebf1de"]DEF[/TD]
[TD="class: xl66, width: 64, bgcolor: #ebf1de, align: right"]0.75[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: #ebf1de"]HYD[/TD]
[TD="class: xl66, width: 64, bgcolor: #ebf1de"]DEF[/TD]
[TD="class: xl66, width: 64, bgcolor: #ebf1de, align: right"]1.25[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 64, bgcolor: #ebf1de"]HYD[/TD]
[TD="class: xl66, width: 64, bgcolor: #ebf1de"]DEF[/TD]
[TD="class: xl66, width: 64, bgcolor: #ebf1de, align: right"]0.25[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #dce6f1"]POZ[/TD]
[TD="class: xl67, bgcolor: #dce6f1"]ABC[/TD]
[TD="class: xl67, bgcolor: #dce6f1, align: right"]0.75[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #dce6f1"]POZ[/TD]
[TD="class: xl67, bgcolor: #dce6f1"]DEF[/TD]
[TD="class: xl67, bgcolor: #dce6f1, align: right"]1.25[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #dce6f1"]POZ[/TD]
[TD="class: xl67, bgcolor: #dce6f1"]DEF[/TD]
[TD="class: xl67, bgcolor: #dce6f1, align: right"]0.25[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #dce6f1"]POZ[/TD]
[TD="class: xl67, bgcolor: #dce6f1"]ABC[/TD]
[TD="class: xl67, bgcolor: #dce6f1, align: right"]0.75[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 64, bgcolor: #e4dfec"]TOR[/TD]
[TD="class: xl68, width: 64, bgcolor: #e4dfec"]DEF[/TD]
[TD="class: xl68, width: 64, bgcolor: #e4dfec, align: right"]1.25[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 64, bgcolor: #e4dfec"]TOR[/TD]
[TD="class: xl68, width: 64, bgcolor: #e4dfec"]ABC[/TD]
[TD="class: xl68, width: 64, bgcolor: #e4dfec, align: right"]0.25[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 64, bgcolor: #e4dfec"]TOR[/TD]
[TD="class: xl68, width: 64, bgcolor: #e4dfec"]DEF[/TD]
[TD="class: xl68, width: 64, bgcolor: #e4dfec, align: right"]0.75[/TD]
[/TR]
[TR]
[TD="class: xl68, width: 64, bgcolor: #e4dfec"]TOR[/TD]
[TD="class: xl68, width: 64, bgcolor: #e4dfec"]DEF[/TD]
[TD="class: xl68, width: 64, bgcolor: #e4dfec, align: right"]1.25[/TD]
[/TR]
</TBODY>[/TABLE]


Regards,
Ren.