[CharlesCrisp]

Im doing a v-look up table, and Im trying to figure out what I need to do to correct my current formula as it is not working. I've done everything apart from 1 thing (I think) in the formula and I don't know what to put?! :S It's the col_index_num.
Heres a pic:

<a href="http://s198.photobucket.com/albums/a...t=spread-1.jpg" target="_blank"><img src="http://i198.photobucket.com/albums/a...y/spread-1.jpg" border="0" alt="Photobucket"></a>

[Gazmondo]

H2 to H10 are formatted as text, and E9 is a number.

Excel does not recognise 1 to 5 as 1 or 2 or 3 or 4 or 5. It simply sees it as 1 to 5.

To rectify your table, the simplest method (there will be an advanced more complicated solution but it is beyond my excel knowledge) would be to re-arrange your table to this:

Total Marks - Grade
1 - F
2 - F
3 - F
4 - F
5 - F
6 - E
7 - E
8 - E
9 - E
10 - E

etc etc.

This method would work but it is by no means the best.

[CharlesCrisp]

Thanks very much for your help! However now it performs its function BUT.... it only calculates what grade someone should get in E9 onwards. I want it to calculate the G9 onwards aswell. However when I type E9:G9 in, it includes the yes/no box aswell, and the formula dusnt function. How do I avoid this?

<a href="http://s198.photobucket.com/albums/a...t=untitled.jpg" target="_blank"><img src="http://i198.photobucket.com/albums/a...y/untitled.jpg" border="0" alt="Photobucket"></a>