excel formula

[mlfrady]

I need to be able to change 100s of course numbers to useful information. How can I change a column of course numbers and replace it with the information that the course numbers represent?

 

[PaddyD]

you need:

a) a master 'lookup table' that lists all the possible code / description combinations and
b) a formula that extracts the information.

Take a look at the example:

With the lookup table in a2:b9, you can use a vlookup formula to return the relevant descriptions -

Book6
	A	B	C	D	E
1	LookupTable			Data	Result
2	Code	Desc		c	Part3
3	a	Part1		a	Part1
4	b	Part2		f	Part6
5	c	Part3
6	d	Part4
7	e	Part5
8	f	Part6
9	g	Part7
10
Sheet2

check out vlookup in the help & post back if you need more info.

Paddy