Best way to assign a range?

[BigBeachBananas]

I have age data and I want to group them according to the lookup on the right. What's the simplest way to do it?

GENLI_ASSUMED.xlsx
	A	B	C	D	E	F
1	Data			Lookup Table
2	Age	Age Band		Min	Max	Issue Age Band
3	1			0	20	0-20
4	12			21	30	21-30
5	25			31	40	31-40
6	16			41	50	41-50
7	70			51	60	51-60
8	41			61	70	61-70
9				70		70+
Sheet2

 

[Fluff]

How about

=VLOOKUP(A3,$D$3:$F$9,3,1)

 

[BigBeachBananas]

How about

=VLOOKUP(A3,$D$3:$F$9,3,1)

Thanks for the quick answer! What does the 1 (the fourth parameter) do?

 

[Fluff]

It means an approximate match, rather than an exact match.