I continue to appreciate your assistance.

[Damil4real]

I have a list of data1 (data is alphabets e.g. NWPE, but sometimes can
be in numbers e.g 4589) in Column N (from N4:N200). I have another
list of data2 in Column P. I want to put a code in Column O and make
it in sure a way that when I type the alphabet or number data in
Column N & type a list of data in Column P, Column O will show this:

Data1 (Customer Account # Data2) is completed.

Example:

Column N4 | Column
O4 | Column P4
NWPE NWPE (Customer Account # 1549) is
completed 1549
4589 4589 (Customer Account # 2009) is
completed 2009

Thanks!

 

[muddan madhu]

try this

=IF(AND(N4<>"",P4<>""),N4&" (Customer Account # "&P4&" ) is completed
","")

 

[Damil4real]

try this

=IF(AND(N4<>"",P4<>""),N4&" (Customer Account # "&P4&" ) is completed
","")





- Show quoted text -

Genuis! Worked great!

Thanks!