Hi,

I really dont know if this is possible - I think I need to combine IF and VLOOKUP but if anyone has an alternative please let me know.

So I have a report of several hundred lines. I want a formula that takes a cell (per line) and looks it up against a table.

For example;

Score
10
15
20
25

Table

Score Grade
1 - 9 A
10-14 B
15-19 C

etc

So I basically want my formula to say 'Take this mark and look up against my table. IF the score is >= 1 but < 9 give A, >= 10 but < 14 give B . . . . ' etc

I want the formula to grade all the lines in my report.

I hope this makes sense.

Is it possible?