see response to your posting in excel.misc

--
Regards

Roger Govier


"sike11 via OfficeKB.com" <u21678@uwe wrote in message
news:6c83fbaeba87d@uwe...
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