Need a formula to assign prices to values

[Ima_learnin']

Hi All, If I have in column A values that range from $150k to $399k and need to assign a price in column B with amounts between $650.00 to $750.00 what would be the formula? I tried listing out some random prices $651,$673,$687,$691,$702,$724,$734,$750 and used the following formula =CHOOSE(RANDBETWEEN(1,8),$G$3,$G$4,$G$5,$G$6,$G$7,$G$8,$G$9,$G$10) but then realized I need the prices to not be entirely random they need to increase in price as the values in column A increase

 

[rondeondo]

how does column B relate to column A?

 

[Ima_learnin']

Column B is the price of the value in column A

 

[rondeondo]

Can you please post some sample data and explain how the values relate, ie show what you are starting with and what you want to calculate.
For example, if A1=$150,000, then B1=$651. so you want B1 to be A1 / 230. How do you want to arrive at the value for B1? You've said you've tried random numbers based on G3 to G10 is this where you get your result from?
Maybe you're looking for something like the rank function, so to match the highest value in column A with the highest in Column G.