Return Value If It Falls Within Values In Range Of Cells?

I am trying to learn more about functions like IF(), AND() MATCH() and LOOKUP()... but so far I cant seem to get it right. I am actually trying to get a simple working formula that can take a value from the first tab and cross reference it with a table in the second tab to return another value in the first tab.

For example....

On the first tab/sheet named "Details", i have a list of people, an area of work they fall in and then a column named region that categorizes their areas of work into groups

A
B
C

1
Name
Area of Work
Region

2
Mr A
J
?

3
Mr B
6
?

4
Mr D
Z
?

5
Mr E
18
?

Then on the next tab/sheet named "Category", I have a table which lists the areas that belong to a region;

A
B

1
Region
Area

2
1
A-J. 1-6

3
2
K-P, 7-15

4
3
Q-U,W,Z,16-20

I have tried formulas like IF(AND(B2=Category.B2),"1","ERROR") but it keeps returning me "ERROR" when it should return "1"