ok, I'll give it a shot. Ome other questions, on a different note. Lets say
I have a cell that has a whole bunhc of differents words in this 1 cell. Is
there a way I can list these words in alphabetical order?

Eric

"EC" wrote:

All,

I have a worksheet full of data that is sorted by account number. I wasnt
to write a lookup up formula that will look at the 'data tab' and if the
account num,ber matches a certain account, then it will pull all of the
information for that account number. For example, in colunm A there are a
list of account numbers and from columns b thru z there is info. I want to
write a formula that will lookup up the account number I want from column A
and if it matches, give me all of the other info.

Any and all help is greatly appreciated.

Eric