Better tackled with VLookup.

Create a 2 column array somewhere on your sheet like this

Btec national 1
AS Economics 2
GCE maths 3

An put this formula =VLOOKUP(A1,H1:I3,2,FALSE) in B2
in the above case the array is in columns H & I rows 1 to 3. Adjust to suit.
Mike




"sike11 via OfficeKB.com" wrote:

Hi All,

Please help!!

My problem is the following:

I have text in a column like this

A1
BTEC National Diploma
AS Economics
GCSE Maths

What I would like to happen in the next column is a formula like the
following:

IF A1 = "BTEC National" then A2 = 1
ELSE
IF A1 = "AS" then A2 = 2
ELSE
IF A1 = "GCSE" then A2 = 3

I am a little stumped as to how achieve this. Any ideas?

Thank you in advance!

Mary.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1