Grouping Based on Values

[Excel_77]

Hi All,

I have values in column L such as the following:

400,000
300,300
1,230,340


I want to group these into certain bands within Column M, the band are listed within a separate tab called "Bands" and the options are as follows - how can I code this? I fear the word "Euro" could cause problems?

01 000 000 to below 01 500 000 Euro

01 500 000 to below 02 000 000 Euro

02 000 000 to below 02 500 000 Euro

02 500 000 to below 03 000 000 Euro

03 000 000 to below 03 500 000 Euro

03 500 000 to below 04 000 000 Euro

04 000 000 to below 04 500 000 Euro

04 500 000 to below 05 000 000 Euro

05 000 000 to below 06 000 000 Euro

06 000 000 to below 07 000 000 Euro

07 000 000 to below 08 000 000 Euro

08 000 000 to below 09 000 000 Euro

11 000 000 to below 12 000 000 Euro

13 000 000 to below 14 000 000 Euro

below 01 000 000 Euro

<tbody>
</tbody><colgroup><col></colgroup>

 

[Special-K99]

"how can I code this"
Youre looking for a VBA solution then not a formula ?

 

[Excel_77]

"how can I code this"
Youre looking for a VBA solution then not a formula ?

No Excel formula, poor wording on my part.

 

[Joe4]

I am not quite clear what exactly you want to return for each of the bands it something falls into.
So, for your first example, 400,000 that would fall in your 400,000 to 450,000 band.
So what exactly do you want it to return?