This question is long winded so forgive me.

I need to develop a function that takes an identifer matches that id with an
id on a subsequent worksheet and returns a value for that id which is then
used in a math function to calculate forecast.

i.e.
Worksheet 1
ID Item Budget Forecasted Amount
3 Oranges $300 ?
1 Apples $32 ?
3 Oranges $212 ?
5 Pears $198 ?

Worksheet 2
ID Item Cost Per
1 Grapes $0.70
2 Berries $0.25
3 Oranges $0.50
4 Bananas $0.55
5 Pears $0.90

So basically the function i need is that if the client on the first line
item has $300 to spend on oranges and oranges cost $0.50 each based off
Worksheet 2 then how many oranges can the client expect?