how to find some account no in all account no using formula ?

sir , i have three column A B C,D

in column A there are all old account no,

in column B there are new account no

in column c ihave a list of some old account no

i want to find some old account no. which is in column C, from column A and in colmn D it should be replace by new account no like:

    A           B C D
550 1234 552 1236
551 1235 554 1238
552 1236    
553 1237    
554 1238    

 

By: praveen

Leave a Reply

Your email address will not be published. Required fields are marked *