Here is what I need to be able to do.

I have 9 columns of clients account numbers as the header.
Each row is a trade that belongs to one of the 9 accounts.

I need to have the 10th column have the account the trade is for
written.

So for example I think I want to do something like this:
If G7 <”” then make P7=”1P”
Or
If H7 <”” then make P7=”2P”
Or
If I7 < “” then make P7=”3P”

And so on.

Just don’t know how to do it.

Thanks in advance,
Ken


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