That seems the right way, also could use a vlookup function and another table

"Special-K" wrote:


Assuming Data Are and Tank are columns A B and C isnt this just a simple
case of in column D entering the formula

=IF(B1="Hp",1,IF(B1="Lp",2,IF(B1=Shut",3,IF(B1="Te st",4,"UNKNOWN"))))

Then copy the formula down the D column

(Im sure theres a simpler formula to use to produce this)


--
Special-K
------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=561109