Oct 28 2022 08:52 AM
Oct 28 2022 08:52 AM
I have 2 sheets, and they share one value, the customer ID, so, I need to cross the information between. Taking in consideration the Customer ID, I need to know the page URL who generated the sale.
What I've accomplished until now? With the the countif function I was able to see if a value from sheet 1 is also in sheet 2. What I need? If Customer ID on sheet 2 matches customer ID of sheet 1, that I need to copy the value of page URL of the row of sheet 2 to sheet 1.
Hoping that I was clear. Thanks in advance for all your help.
|Nome Paciente||Customer ID / Nº Processo||Data criação Paciente||Contacto Paciente||Email Paciente||Clinica||Data Consulta||Tipo Consulta||Estado da Consulta||Estado Proposta||Data Venda Proposta||Tipo Proposta||Valor Proposta €||id_referenciador_pt||Paciente KO||Provisório||Formação||MTC OK||Valor Faturado €||Website URL|
|Nam1||196835901||03-04-2022||xxxx1||email address removed for privacy reasons||Braga||10/08/2021||Presencial||Efetivada||Comprou||01/04/2022||Transplante capilar||3250||NAO||NAO||NAO||SIM||3250|
|Nam2||239875651||03-04-2022||xxxx2||email address removed for privacy reasons||Braga||02/04/2022||Presencial||Efetivada||Comprou||02/04/2022||Transplante capilar||4500||9995||NAO||NAO||NAO||SIM||4500|
|Nam3||205898401||03-04-2022||xxxx3||email address removed for privacy reasons||Braga||02/04/2022||Presencial||Efetivada||Comprou||02/04/2022||Transplante capilar||4250||8902||NAO||SIM||NAO||SIM||0|
|Nam4||228816855||03-04-2022||xxxx4||email address removed for privacy reasons||Braga||02/04/2022||Presencial||Efetivada||Comprou||02/04/2022||Transplante capilar||4500||NAO||NAO||NAO||SIM||4500|
|Nam5||199677751||04-04-2022||xxxx5||email address removed for privacy reasons||Braga||04/04/2022||Presencial||Efetivada||Comprou||04/04/2022||Transplante capilar||4500||NAO||NAO||NAO||SIM||0|
|First Name||Phone Number||Website URL||Contact ID||Contact ID Match|
|Nam1||xxxx1||email address removed for privacy reasons||https://www.example.com/1||196835901||0|
|Nam2||xxxx2||email address removed for privacy reasons||https://www.example.com/2||239875651||1|
|Nam3||xxxx3||email address removed for privacy reasons||https://www.example.com/3||205898401||1|
|Nam4||xxxx4||email address removed for privacy reasons||https://www.example.com/4||228816855||0|
|Nam5||xxxx5||email address removed for privacy reasons||https://www.example.com/5||199677751||0|
Oct 30 2022 06:33 AM
or with VBA, if this is posible in your excel Version.
the code or the file is from a long time ago and I don't even know where it can be from (internet site or from me), but it should work. Code can be found in the file.
Hope I was able to help you :).
I know I don't know anything (Socrates)
Oct 30 2022 07:02 AMSolution
An alternative could be Power Query.