I continue to appreciate your assistance.

  • Thread starter Thread starter Damil4real
  • Start date Start date
D

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!
 
try this

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