Hi,

Thanks for the suggestion. However, it did not work as A2 was blank. Any
other ideas?

Alan wrote:
In A2,
=IF(A1="BTEC",1,IF(A1="AS",2,IF(A1="GCSE",3,"") ))
Regards,
Alan.
Hi All,

[quoted text clipped - 23 lines]

Mary.

--
Message posted via http://www.officekb.com