formatting according to cell content

0

I have a spreadsheet with columns A, B, C, and D where column A, B, and C is a PROCV where you search for the e-mail address in other spreadsheets of each vendor and column D is the name of the person responsible, A, B, and C represent each salesperson on my team, so when procv finds the email address on each salesperson's worksheet it returns that address, otherwise it returns unallocated text.

My need, when the address was found in column A by procv in the responsible column which is D to display seller1, when it is found in column B, display in column D seller2, and so on.

Can you help?

    
asked by anonymous 24.10.2017 / 15:07

1 answer

1

See if I can understand and try the following formula in column 'D' (cell D1):

=SE(E(A1<>"";ÉERROS(PROCURAR("não";A1)));A1;SE(E(B1<>"";ÉERROS(PROCURAR("não";B1)));B1;SE(E(C1<>"";ÉERROS(PROCURAR("não";C1)));C1;"Não alocado")))
  

If it works in cell D1 replicate to the other cells.

    
24.10.2017 / 16:14