Find data based on search criteria

Hello!
I need some help with finding the correct formula.
I am trying to create a formula that will identify the horse population for a given postcode area. I've created a table with each UK postcode area, and the horse population for each of these. The horse population varies between 5 possibilities:
0-25 horses per 10km2
26-50 horses per 10km2
51-75 horses per 10km2
76-100 horses per 10km2
101-130 horses per 10km2

So my table looks like this (these are the first few lines:
Postcode area Horses per 10km2
AB 0-25
AL 76-100
B 51-75
BA 51-75
BB 26-50
BD 26-50
BH 51-75
BL 76-100
BN 76-100
BR 0-25
BS 51-75
CA 0-25
CB 101-130
CF 51-75
CH 0-25
CM 26-50
CO 26-50

I need a cell where I enter the postcode letters and it lets me know which one of the horse population density it is. Does that make sense? Sorry I am rubbish at explaining! I was told to use an IF function but I'm not sure how to use an IF function for so many possibilities?

Thanks for your help!

Moderatro's note: I have changed your tite for you For future reference, please consider using titles that describe your problem

VLookup will do the job for you.

Hi, welcome to the forum

Maybe this...

	A	B	C
1	AB	0-25	ab
2	AL	76-100	0-25
3	B	51-75
4	BA	51-75
5	BB	26-50
6	BD	26-50
7	BH	51-75
8	BL	76-100
9	BN	76-100
10	BR	0-25
11	BS	51-75
12	CA	0-25
13	CB	101-130
14	CF	51-75
15	CH	0-25
16	CM	26-50
17	CO	26-50

C1=search criteria
C2=IFERROR(VLOOKUP(C1,$A$1:$B$17,2,0),"Post Code Not Found")

Thanks for the reply.

Glad I could help.

You can add rep(utation)point to the one's who helped you, by clicking on the star on the left side.

How about sharing an excel file, without confidential information?

Please add also the desired (expected) result.