Hi guys,
I have the following formula in cell S2.
I need to run the formula above if the value in R2 starts with a letter, and the formula below if it starts with a number:![]()
=IFERROR(VLOOKUP(R2,gradetopoints,2,0),"")
But I need it all to be in one long formula.![]()
=IFERROR(VLOOKUP(R2,leveltopoints,2,0),"")
Many thanks,
Luke
Bookmarks