Hello, everyone,
I have a table with 2 worksheets.
In the 2nd worksheet are intervals from which I want to read numbers based on the first worksheet.
The numbers in column A of the worksheet 'Grade' are given and shall be compared with column A in the worksheet 'interval'.
The corresponding grade should be retrieved in column B of the worksheet 'grade'.
I hope you have a formula for me.
My index formula does not work.
b1.jpg
b2.jpg
Bookmarks