oalkhalili
New Member
- Joined
- Jun 25, 2015
- Messages
- 6
Hello,
I have to use index with match functions to find the correct cell in the matrix grade range A2:F16. I had tracked the error by a simple VLOOKUP. Below image shows the vlookup I am trying to use to find the result values for I19, based on the the range B20:C30. The vlookup works on all percentages except 6%, 10% and 11%; I receive #N/A error. I could not figure out why.
I hope someone can help with this.
Thank you,
I have to use index with match functions to find the correct cell in the matrix grade range A2:F16. I had tracked the error by a simple VLOOKUP. Below image shows the vlookup I am trying to use to find the result values for I19, based on the the range B20:C30. The vlookup works on all percentages except 6%, 10% and 11%; I receive #N/A error. I could not figure out why.
I hope someone can help with this.
Thank you,