minimum maximum value formulating

[berbs]

I am trying to put a corresponding value in a certain cell from a value in another cell. It will require me to do a "if this number is between two numbers in two columns" then it states the value to be inserted in a certain cell. I am having a problem figuring out what kind of formula to use (vlookup, match??). I can show an example of a screenshot if anybody would like to help me with this. thanks.

an example of the terminology:
if the number in cell H9 is between the minimum column number in AF8 and maximum column number in AG8 then it will return the number that is in cell AH8 and puts it in cell H4. This is for a golf handicap computation which uses the "conversion chart" in cells AF8:AG48.

 

[DanteAmor]

I am not a golfer, nor a bowler, nor an accountant, nor do I have many professions, but here we make many formulas for many calculations.
Only explain with examples what you have, what data to use for the calculation and what result you expect.