if you create a table say in e2:f5
Hp 1
Lp 2
Test 3
Shut 4

then in the say cell d2 =vlookup(c2,$e$2:$f$5,2,false) and copy it
down

or

=if(c2="Hp",1,if(c2="Lp",2,if(c2="Test",3,if(c2="s hut",""))))

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561109