I am dealing with 2 columns like below. What I want to do, via VBA, is to provide a number, say $3050, match it against column A (rounding up if necessary) and returning the item from column B.


For instance

mystring = "3150"
Value (COL A) Perecentage (COL B)
$3,000 95%
$3,100 94.8%
$3,200 94.6%
$4000 94.4%

3150, should return 94.6%. It should always round up and numbers should always be between 3000-15000, I know my qualifier is:
If mystring > 3000 and mystring < 15000 Then

'do stuff here

end if
just not sure about how I should try to match the values up, thanks!