IF statement for non-consecutive numbers

So the score in column A is the variable.
The grouping (B) is organised in numerical order, i.e. 1-5 = home, so is easy to categorise using IF.
The categories (C) exist within each grouping, so each grouping has each of the categories, thus I would like the IF statement to put A for a score of 1, 5 and 8.

If that makes sense?

Right now I'm doing separate columns for all 6 categories, but I have to do it twice, so it takes up a lot of space. Unless there is a simpler method of doing it, then I'll just keep it this way.

Create a 2 column table with the score in the left column and the corresponding category in the right column.

Then you can use a VLOOKUP function:

Data Range

	A	B	C	D	E	F
1	Score	Grouping	Category		Score	Category
2	1	Home	A		1	A
3	3	Home	C		2	B
4	5	Work	A		3	C
5	7	Work	C		4	B
6	3	Home	C		5	A
7	2	Home	B		6	B
8	9	Work	E		7	C
9	6	Work	B		8	A
10	12	Misc	E		9	E
11	11	Misc	D		10	C
12	8	Misc	A		11	D
13	3	Home	C		12	E
14	2	Home	B
15	1	Home	A	------	------	------

This formula entered in B2 and copied down:

=VLOOKUP(A2,E$2:F$13,2,0)

You're welcome!