Match multiple values

[AmiExcel]

Hi, wondering if anyone could help?

I am trying to find a formula which can tell me if the numbers in that cell match another number - but for a range of numbers.

To explain further, here is some data:

Scores

Satisfaction
Work	4​
Relationships	3​
Friendships	8​
Hobbies	1​

Score interpretations

Satisfaction	Work	Relationships	Friendships	Hobbies
High
Mid
Low

Key

High	7 to 8
Mid	4 to 6
Low	1 to 3

I was wondering what formula I would have to use in the score interpretation table which will allow me to determine which level of satisfaction is true for each domain. I can use =AND(EXACT(()) for single match values but for this data multiple values mean high (7,8), mid (4,5,6) and low (1,2,3).

I hope this makes sense! Let me know if you have any questions

Also, I am using excel 2019

 

[offthelip]

high =AND(A2>=7,A2<=8)
mid =AND(A2>=4,A2<=6)
low =AND(A2>=1,A2<=3)

​

 

[Nishant94]

Satisfaction
Work	4
Relationships	3
Friendships	8
Hobbies	1
Score interpretations
Satisfaction	Work	Relationships	Friendships	Hobbies
High			High
Mid	Mid
Low		Low		Low

Formula in B9, assuming the 1st table in range A2:B5:

=IF(VLOOKUP(VLOOKUP(B$8,$A$2:$B$5,2,0),{7,"High";8,"High";4,"Mid";5,"Mid";6,"Mid";1,"Low";2,"Low";3,"Low"},2,0)=$A9,VLOOKUP(VLOOKUP(B$8,$A$2:$B$5,2,0),{7,"High";8,"High";4,"Mid";5,"Mid";6,"Mid";1,"Low";2,"Low";3,"Low"},2,0),"")