Lookup for multiple columns against a single list of values

[LJDL]

I have a dataset similar to the sample below;

Data:

Person	GENDER	NATION	AGE	ETHNICITY
1	0	1	5	8
2	3	1	3	8
3	0	0	5	7
4	2	0	1	4
5	3	0	5	7
6	2	1	1	8
7	1	0	4	9
8	0	1	5	8
9	3	1	5	3
10	2	0	2	9

I then have a separate, single lookup file setup like this;

Lookup:

Field	Label	Description
GENDER	0	Female
GENDER	1	Male
GENDER	3	Other
NATION	0	UK
NATION	1	Other (including unknown)
AGE	1	20 and under
AGE	2	21 to 24
AGE	3	25 to 29
AGE	4	30 and over
AGE	5	Unknown
ETHNICITY	1	White
ETHNICITY	2	Black Caribbean
ETHNICITY	3	Black African
ETHNICITY	4	Indian
ETHNICITY	5	Pakinstani
ETHNICITY	6	Bangladeshi
ETHNICITY	7	Chinese
ETHNICITY	8	Mixed
ETHNICITY	9	Other
ETHNICITY	10	Unknown

Which tool(s) can I use to take the appropriate Description and replace the label in the corresponding field in the dataset? The dataset has 35 columns and there are 200+ rows in the lookup table.

Thanks in advance

John

[LJDL]

Thanks for you help @Luke_C my lookup table is outside of my control and contains letters as well as numbers so this time I've used the transpose and cross-tab method. The dynamic replace looks very interesting though and now I've got your example I can think of other places where I can use it.