flavatech
New member
- Joined
- Dec 7, 2014
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hi all,
I would like a little assistance with a grade sheet that I am currently working on. I have attached the workbook and I have highlighted the area (Blue) in the worksheet named ARRAY from which the formulae is supposed to search. I have changed the colour of the incorrect value that the formulae returns (red) and I have also shown the correct value that the formulae should return Violet/Yellow. I have tried numerous things. I just cant eem to figure out why the formulae stops searching at the incorrect value. Any assistance will be appreciated.View attachment flava 60-40 Degree Grade Sheet Redesigned December 2014.xls
I would like a little assistance with a grade sheet that I am currently working on. I have attached the workbook and I have highlighted the area (Blue) in the worksheet named ARRAY from which the formulae is supposed to search. I have changed the colour of the incorrect value that the formulae returns (red) and I have also shown the correct value that the formulae should return Violet/Yellow. I have tried numerous things. I just cant eem to figure out why the formulae stops searching at the incorrect value. Any assistance will be appreciated.View attachment flava 60-40 Degree Grade Sheet Redesigned December 2014.xls