VBA to replace multiple values with specific labels

Why VBA?
I'd honestly recommend use of Vlookup function like the one in attached file.

Of course you can do this with VBA but then we have too little information. for instance selec a range with such numbers and run for instance such macro:

Please Login or Register  to view this content.

try selecting B2:B4 in attachment from previous post and run it. of course after such macro formula in column C will return errors

I'd suggest first creating a 'lookup' table, which maps ages to your required groups:

	A	B
1	Age	Age Group
2	24	20-24
3	25	25-29
4	26	25-29
5	27	25-29
6	28	25-29
7	29	25-29
8	30	30-34
9	31	30-34
10	etc

Then you can use a bit of code to replace age values with age group values:

Please Login or Register  to view this content.