Ken,

I think that Biff suggestion of being VERY specific in what it is you are
trying to do is very valid. In the mean time, if you are still using G7:K7
then to return the numbers you gave try:

="3B"&CHOOSE(MIN(IF(G7:K7<"",--(G7:K7<"")*({1,2,3,4,5}))),123,454,550,590,625)

entered as an array formula with Ctrl + Shift + Enter not just Enter

I had worked it out so it seemed a waste not to post it <g
--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"sungen99" wrote in
message ...

Ah. no no- im not explaining it correctly. the actual account numbers
are those. That's what I want to be displayed. not 1p 2p 3p and so on.


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=493117