Need to derive curve from values, then apply curve to another data set

I have a data set (Set#1) that consists of a positional rank (1-240) and a dollar value ($46-$1) for each positional rank. It's not a straight line set.

DataSet.JPG

What I need to do is take that curve and apply it to another data set (Set#2) (1-240) and assign a dollar value ($46-$1) to each positional rank.

A "corner cutting" way of doing it would be an Index/Match to simply carry over the dollar value from (for example) #45 from my Set#1 to #45 in my Set#2. This could work reasonably well with data sets of the same size, but mine aren't always the same size, so I need to apply the curve itself. I imagine I'll probably have to work with percentiles and such, but I'm just not sure how to go about this.

Any ideas?

This reminds me of highschool physics, in which we solved this by a using a change of axies. So you do a linear fit to g(x) vs f(y), and solve f(y)=m*g(x)+b for y to get your equation.

looks like your data fits a y=1/x curve. Setup the following data table

Data Table Example.png

note: in the exampel g(x)=x, and f(y)=1/y