I have a table that looks something like this:
100-76 51-75 26-50 0-25
$2.5m-$5m 6.02 6.65 7.28 7.28
$5m - $7m 5.47 6.03 6.59 7.17
$7.5m-$10m 5.21 5.78 6.39 6.99

Say in another worksheet (sheet2) in cell A1 I have a figure of $6m & next
to that in cell A2 I have a figure of 55, is it possible for excel to look at
those two numbers and using the column and row ranges pick out the correct
value from the table of 6.03???
Your help would be greatly appreciated.
Many thanks,