Forum Discussion
Changing vlookup array based on a cell value
There are different classifications for scores based on a student's grade. I can do multiple IF statements (see column D), but that requires filtering by grade and editing the formula several times....
If it's possible to keep your sub level range in reverse order
the formula could be easier, like
=VLOOKUP($C2,INDEX($O$2:$U$2,$B2-1):$V$9,10-$B2)If I understood your logic correctly.
Thank you! Than worked perfectly, too, and the 'reversed' order was the original from the source.