Matching a value to a column, (rounding) and returning offset column value

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

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

Thanks to both of you! I could do either one but im automating with access and vba so the vba alternative makes more sense I think