<colgroup><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody> </tbody> |
<tbody>
</tbody>
Ok, So I want to lookup the type column in row B "A,L,R,E" and match it with the type column in column F, then return the "return code" for the code in column B that falls between the two tolerance columns in column I and J. I want this to be the equation in column D (which has the correct values that I would like it to return).
For example if the value in column B is "E" and the code in column C is "5201", I'd like the value returned to column D to find the match in column F of "E" and find the row that the code falls between the two tolerances, in this case "e" and "5201" fall within row 28 where the return code would be "4060"