I would like to know which formula should i use in this case:

I have one worksheet with these values:
1st worksheet
Column A B
1,045.00 ‚¬ 1.20
1,050.00 ‚¬ 1.60
1,055.00 ‚¬ 2.00
1,060.00 ‚¬ 2.40
1,065.00 ‚¬ 2.80
1,070.00 ‚¬ 3.20
1,075.00 ‚¬ 3.60
1,080.00 ‚¬ 4.10
1,085.00 ‚¬ 4.50
1,090.00 ‚¬ 4.90
1,095.00 ‚¬ 5.30
1,100.00 ‚¬ 5.70
(each value on column A corresponds to the one in column B)

2nd worksheet
Then, i have a result .
If i have a result between 1045 and <1050, how can i attribute in another
cell 1.20.

Thank you
Jimmy