LookUp Problem
I need to look at a single cell and it will contain a value from 1-1000, I
want to return different letters based on the cell value. Using ranges for
different letters
Example - 1-100 will return an A, 101-150 will return a B, etc. all the way
to 1000 in increments of 50.
The column C will contain the a number between 1 and 1000 and I want to
return a letter based on the example above in a different column.
|