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

Hi and welcome

at first glance there seems to be an overlap in your steel grades

Suppose C =0.10 and Mn=0.50 What would be the grade?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post