Vlookup on minimum difference - VBA loop

[cjohnson309]

Hey All,

This is my first post on the website.

I'm looking to get a vlookup value based on the closest value. I have 3 different buckets with their different numbers. They do not exactly match the list on the left so i'm looking for a formula / VBA loop to automatically show the bucket name like so below next to the closest value.

I'm really looking for a VBA loop where it will first set Bucket #1 to the closest value, then when it is set, it will move on to Bucket #2 , etc.

Thanks!
Connor

5			Bucket #1	11
10	Bucket #1		Bucket #2	32
15			Bucket #3	46
20
25
30	Bucket #2
35
40
45	Bucket #3

<tbody>
</tbody>