Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ={"Attention";
- "Information";
- "Lead";
- "Contact";
- "Sales";
- "After-Sales"}
- =ARRAYFORMULA(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
- VLOOKUP(B16:B21, FILTER({E2:E13, D2:D13}, B2:B13="Persona 1"), 2, 0),
- "Website", 1), "Mailbox", 2), "Call", 3)*1)
- =ARRAYFORMULA(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
- VLOOKUP(B16:B21, FILTER({E2:E13, D2:D13}, B2:B13="Persona 2"), 2, 0),
- "Website", 1), "Mailbox", 2), "Call", 3)*1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement