Max, worked a treat !.
Thanks again for your help. Have a great weekend

"Max" wrote:

... ie, change A1 to L4, or does it need to begin at the top of a row?

Yes, just change the A1 to L4 in the earlier formula ..
Put in say, M4:
=IF(OR(L4="",L4<5,L49),"",VLOOKUP(L4,{5,1;6,"2+"; 7,2;8,3;9,4},2,0))
Copy M4 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Greenback" wrote:
Max, many thanks for that. I have tried that but my figures begin in cell
L4...would I just change your formula to suit?, ie, change A1 to L4, or does
it need to begin at the top of a row?

Cheers,