This is obviously my first post on here, so please forgive me if I don't do something right. I am trying to put together a sheet that has inputs for various chemical constituents of a steel, and I would like to determine which grade it is...see below example of what I'm trying to do. I need help with the formulas for searching a range of numbers and outputting if it falls into that category or not. I would love to do this without VBA but will default to the experts on here. Thanks in advance!

Inputs

Input 1
C: 0.15
Mn: 0.75

Input 2
C: 0.22
Mn: 0.35


Steel Grades

L175 Grade


C: 0.00 to 0.21
Mn: 0.00 to 0.60

L210 Grade
C: 0.00 to 0.22
Mn: 0.00 to 0.90