I have Index formulas in cell O5 to O8 looking for exam results. I then want to use the Index formula to locate the cell that has the result in out of Cells O5 to O8 but for some reason it will only work if the result is in O5 and not O6 for example.
=IFERROR(INDEX(O5:O8,MATCH("*",O5:O8,-1)),"") this is my formula
I have added the IfError so if no result is there no error is shown
Bookmarks